Help with formula
 

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?

Help with formula
 

gcotterl wrote:
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

Help with formula
 

On Jun 27, 12:49*pm, smartin wrote:
gcotterlwrote:
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

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

Help with formula
 

gcotterl wrote:
On Jun 27, 12:49 pm, smartin wrote:
gcotterlwrote:
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

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


This is my reply to the other post:
http://groups.google.com/group/micro...a70d56289e553#

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.