If statement help if A1 contains this then return that

[V20agent]

Hello

I can have any of these values (0,1,2,3,4) in in A1.

how do I Make B1 return the following:
if 0 then return "NS"
if 1 then return "G"
if 2 then return "A"
if 3 then return "R"
if 4 then return "C"

how can i write this formula in one line so that it picks up whatever is in A1 and returns the appropriate in B1?

MANY THANKS!

 

[Fluff]

How about

=choose(A1+1,"NS","G","A","R","C")

 

[jtakw]

Hi,

Here's one way:

Book3.xlsx
	A	B
1	0	NS
2	3	R
3	2	A
4	4	C
5	1	G
Sheet861

Cell Formulas
Range	Formula
B1:B5	B1	=CHOOSE(A1+1,"NS","G","A","R","C")

 

[V20agent]

you both are awesome! this is brilliant! thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[jtakw]

You're welcome, thanks for the feedback.

 

[V20agent]

Actually one more thing that i missed. If A1 is blank then B1 returns blank or leave cell empty. how do i do that?

 

[jtakw]

Add a test for blank:

Book3.xlsx
	A	B
1	0	NS
2	3	R
3
4	4	C
5	1	G
Sheet862

Cell Formulas
Range	Formula
B1:B5	B1	=IF(A1="","",CHOOSE(A1+1,"NS","G","A","R","C"))

 

[V20agent]

thank you!! this worked perfectly.

 

[jtakw]

You're welcome, glad to help.