IF STATEMENTS
Posted by Gary on November 20, 2001 1:20 PM
Hi, how do you do multiple IF's in the same cell with a couple of AND's and OR's?? For example, if I am comparing 2 cells and I want to Flag if one cell is > 50 and the other is > 10% or if the first cell is < -50 and the second is < -10%.
PLEASE HELP!!!
Posted by Russell Hauf on November 20, 2001 1:49 PM
How about:
=IF(OR(AND(A1>50,B1>.1),AND(A1<-50,B1<-.1)),"Flag","No Flag")
HTH,
-rh
Posted by Gary on November 20, 2001 2:11 PM
Rob, thanks a lot. It worked perfectly.
Posted by Gary on November 20, 2001 2:11 PM
I meant Russ
