=IF(AND(A10,A1<10),"Maybe",IF(A1=10,"Yes","No"))


"Brent" wrote in message
...
I'd like to create the following formula.

The formula has to include all three steps below.
1) If cell A1:A3000 equal 0.01-10 then the result is Maybe
2) If cell A1:A3000 equal 10 then the result is YES
2) If the cell is empty then the result is NO.

Thanks!