Help with nested conditional formula

  • Thread starter Thread starter GARY
  • Start date Start date
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?
 
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
 
Back
Top