MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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