Excel Formula

  • Thread starter Thread starter Brent
  • Start date Start date
B

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!
 
Brent said:
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.
Click to expand...

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