Excel Formula

[Brent]

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!

 

[JLGWhiz]

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

 

[JoeU2004]

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.

What if A1:A3000 is less than 0.01?

I suspect you want to put the following in some cell parallel to A1 and copy
down through row 3000:

=if(A1="", "NO", if(A1<=10, "Maybe", "YES"))

 

[JLGWhiz]

I was wondering if the OP was looking for the sum of a1:a3000 as a
comparison.

=IF(AND(SUM(A1:A3000)>0,(SUM(A1:A3000)<10)),"Maybe",IF(SUM(A1:A3000)>=10,"Yes","No"))