Joann,

Here you a
=IF(M10<0,"No Order",MIN(J10,L10))

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Joann" wrote:

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