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