If Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RWilson130 - 20 May 2008 20:25 GMT

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!

Reply to this Message

Gary Brown - 20 May 2008 20:44 GMT

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

> 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!

Reply to this Message

RWilson130 - 20 May 2008 21:17 GMT

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!

> I'm going to assume that the 2nd formula was supposed to be...
> IF(T15="BA","X","")
[quoted text clipped - 11 lines]
> >
> > Thanks!

Reply to this Message

David Biddulph - 20 May 2008 21:30 GMT

=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

> No I am trying to do two things here....first i want to know if in cell
> M15 =
[quoted text clipped - 20 lines]
>> >
>> > Thanks!

Reply to this Message

RWilson130 - 20 May 2008 23:20 GMT

Thank You David!!!

> =IF(T15="BA","",IF(M15="L","X",""))
> or
[quoted text clipped - 28 lines]
> >> >
> >> > Thanks!

Reply to this Message