IF and or function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a formaula that says:
If Cell B1 contains SA or A or D or SD then cell C2 reads 4 for SA or 3 for
A or 2 for D or 1 for SD. I hope that makes sense. I know how to do it for
yes and no but not when the cell could have four different entries.
Thank you
 

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

Functions 1
Converting Text 9
Subtotals of repeating set of data 2
compare cells and sum if equal 4
Nested IF AND OR statement 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Nested if 4
sorting using letters , but not alphabetically. 5

Back
Top