difficult formula question
If...M10 is less than zero
If...M10 is greater than zero
Ok, what if M10 = 0?
If M10 is 0 or empty/blank this formula returns a blank:
=IF(M10<0,"no order",IF(COUNT(1/M10),MIN(J10,L10),""))
--
Biff
Microsoft Excel MVP
"Joann" wrote in message
...
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
|