Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |