Help with formula

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

smartin

gcotterl said:
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?
Click to expand...

see other post
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with nested conditional formula 1
Nested "If" statements 1
Excel 2007 - AVERAGEIF on rows that are non-continuous 2
Conditional Formating 1
How do I add more ranges to the following formula? 3
Nesting Eroor - more than 64 3
count if two conditions in two arrays are true 1
AVERAGEIF FORMULA EXCEL 2007 1

Top