Excel Formula
 

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!

Excel Formula
 

=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!

Excel Formula
 

"Brent" wrote:
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"))

Excel Formula
 

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"))


"JoeU2004" wrote in message
...
"Brent" wrote:
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"))