IF statement
Posted by keith on April 06, 2001 9:16 AM
The only other stipulation that I would like to add to the formula below is if c1="x", then b1="", otherwise follow all previous conditions in formula. c1 can only be "x" or empty using validation.
=IF(ISNUMBER(a1),IF(a1<0,"",IF(a1>0.01,"x","")),"")
The above formula is in cell b1 originally looking at a1, but i also want it to consider c1 as described above.
Thanks.
Posted by Aladin Akyurek on April 06, 2001 10:45 AM
Hi Keith
Is this what you are looking for?
=IF(C1="x","",IF(ISNUMBER(A1),IF(A1<0,"",IF(A1>0.01,"x","")),""))
If not, please give a verbal description of the realtions between b1 and the other cells, that is, A1 and C1.
Aladin
