IF and or function

E

EOB

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
 
R

Roger Govier

Hi
Try entering in C2
=IF(B1="SA",4,IF(B1="A",3,IF(B1="D",2,IF(B1="SD",1,""))))
 

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

Newbie Help - IF Yes No Function 0
Possible? Variable X and Y data sources and Auto Charting 0
Nested IF AND OR statement 3
If, Or, and 5
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Excel - Wich Function should I use? 1
Office 365 Email Encryption One time Passcode 0
Template with fields and premade texts.. 0

Top