Help with formula

[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?

 

[smartin]

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?

see other post

 

[gcotterl]

gcotterlwrote:


see other post

What "other post" contains the answer to THIS question?

 

[smartin]

What "other post" contains the answer to THIS question?

This is my reply to the other post:
http://groups.google.com/group/micr...amming/browse_thread/thread/692a70d56289e553#

Ah, I see now the current question is slightly different than the
previous one. But this question doesn't make sense, as you have too many
"else" cases.