Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 78

difficult formula question

I am trying to write a formula & am stuck on the last part.

If the value of M10 is less than zero, then I wan "no order" to display.
If the value of M10 is greater than zero, then I want the lesser value of
L10 & J10 to display.

Here is what i have thus far =If(not(m100), "no order",

I don't know how to write it so it pulls the lesser of L10 or J10
though...please help

Joann

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Difficult formula question	JRD-CFW	Excel Worksheet Functions	7	October 3rd 08 10:22 PM
Difficult ------------- question	woo	Excel Discussion (Misc queries)	1	May 6th 07 04:23 AM
difficult question	Wu	Excel Discussion (Misc queries)	2	April 1st 07 03:10 PM
Difficult (at least to me) formula question	darkwood	Excel Worksheet Functions	5	December 29th 05 01:39 PM
Very simple, but difficult formula question	pugsly8422	Excel Worksheet Functions	4	July 7th 05 03:14 PM

All times are GMT +1. The time now is 03:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us