Multiple formula trouble

[cmisero]

I'm sure this has been asked a million times so I apologize for the repetitiveness.

Having trouble entering multiple formulas in a cell

Example what I have so far:

In Cell A1

=IF(A2=7, "A")

That means if cell A2 value is 7 then it will put an A in cell A1.
Got that good so far.
How do I make multiple rules?
=IF(A2=8,"B")
=IF(A2=9,"C")

I think I have the formulas down, just can't for the life of me remember how to combine them into one formula for the selected cell.

Thanks in Advance!

 

[Joe4]

Welcome to the Board!

If you want it all in one cell, you want to nest your IF statements, i.e.

=IF(A2=7,"A",IF(A2=8,"B",IF(A2=9,"C","")))

 

[jtakw]

Hi,

You can also use the LOOKUP function for your scenario:

Book1
	A	B	C	D	E	F	G
1	A	B	C	#N/A	#N/A
2	7	8	9		5		5
Sheet4

Cell Formulas
Range	Formula
A1	=LOOKUP(A2,{7,8,9},{"A","B","C"})
F1	=IFERROR(LOOKUP(F2,{7,8,9},{"A","B","C"}),"")

A1 formula copied across to E1, if you may have BLANK or values other than 7, 8, or 9 in row 2, then wrap the formula with IFERROR as shown in F1 (copied to G1 in sample).

 

[cmisero]

Worked perfect! Thanks for the refresher!