If Statement
=IF(T15="BA","",IF(M15="L","X",""))
or
=IF(OR(T15="BA",M15<"L"),"","X")
or
=IF(AND(T15<"BA",M15="L"),"X","")
--
David Biddulph
"RWilson130" wrote in message
...
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!
"Gary Brown" wrote:
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
"RWilson130" wrote:
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!
|