Help with formula

  • Thread starter Thread starter gcotterl
  • Start date Start date
G

gcotterl

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



How do I write the formula?
 
Back
Top