Nested "If" statements

[gcotterl]

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?

 

[Shane Devenshire]

Hi,

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