@IF Formula w/ multiple outcomes

C

Calicokitty

Trying to do a basic excel formula that would show the following:

If cell A1=A,X,but if cell A1=B,Y,or if cell A1=C,Z

Not sure how to work multiple @IF statements versus just a true/fals
answer. Thx for any help
 
F

Frank Kabel

Hi
try
=IF(A1="A","X",IF(A1="B","Y",IF(A1="C","Z","not defined")))

if you need more conditions you may consider using VLOOKUP and a lookup
table
 

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

Scrabble Value calculation for Welsh words 0
3 Similar formulas, one returns #VALUE! 4
Logical formatting for multiple values 1
IF statements - 26 combinations 21
FILTERATION ON MULTIPLE CRITERIA OF A COLUMN 2
additional conditions to SUMPRODUCT formula 3
CONDITIONAL SUM ("OR") 14
Deleting lines that use them for formulas 4

Top