Nested "If" statements

G

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?
 

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
Help with formula 3
Conditional Formating 1
Nesting Eroor - more than 64 3
How do I add more ranges to the following formula? 3
Ignore NA in a formula when I type it in a cell 4
Show Hrs:Min 5
Page numbering with Merged Document and IF statements 1

Top