Help with nested conditional formula

G

GARY

If M6 contains "J" or "L"
if the third character in M6 is a "-"
I want S6 to contain ""X"
else, I want S6 to contain "Y"
else, I want S6 to contain "Z".

How do I write the formula?
 
L

Lars-Åke Aspelin

If M6 contains "J" or "L"
if the third character in M6 is a "-"
I want S6 to contain ""X"
else, I want S6 to contain "Y"
else, I want S6 to contain "Z".

How do I write the formula?
Click to expand...

Try this formula in cell S6:

=IF(AND(ISERROR(FIND("J",M6)),ISERROR(FIND("L",M6))),"Z",IF(MID(M6,3,1)="-","X","Y"))

Hope this helps / Lars-Åke
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with formula 1
AVERAGEIF FORMULA EXCEL 2007 1
How do I add more ranges to the following formula? 3
Formula not recognizing reference to "" in IF statement 2
my first excel experience (share portfolio) 2
VLOOKUP question utilizing the right and left of a given column ineed the mid too dont know how to i 1
count if two conditions in two arrays are true 1
Count only visible results of formula 3

Top