If Statement
 

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!

If Statement
 

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!

If Statement
 

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!

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!

If Statement
 

Thank You David!!!

"David Biddulph" wrote:

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