If Statement

R

RWilson130

I have written a formula IF(M15="L","X","") but I want to add to the formula
IF(T15="BA","")

Can anyone help me with this?

Thanks!
 
G

Gary Brown

I'm going to assume that the 2nd formula was supposed to be...
IF(T15="BA","X","")

That would make your 'combined' formula...
IF(or(M15="L", T15="BA"),"X","")

Hope this helps.
Gary Brown
 
R

RWilson130

No I am trying to do two things here....first i want to know if in cell M15 =
L then I need an X, if it doesn't = L then leave it blank, but if T15= BA I
need it to come back a blank no matter if M15 = L or not.

Thanks for your help with this!
 
D

David Biddulph

=IF(T15="BA","",IF(M15="L","X",""))
or
=IF(OR(T15="BA",M15<>"L"),"","X")
or
=IF(AND(T15<>"BA",M15="L"),"X","")
 
Top