IF three conditions

[mustu2]

Hi

I have 3 conditions for IF, but dont know how to add a formula. Please advice.

Currently i have this formula

=IF(E3="0","A","B")

i have three criteria
0
1
2

so if E3 = 0 then its A
E3=1 then its B
E3=2 then its C

please advice
thanks

 

[Gerald Higgins]

=IF(E3=0,"A",IF(E3=1,"B",IF(E3=2,"C","OTHER")))

or, if there is no possibility that E3 is something other than 0, 1 or 2

=IF(E3=0,"A",IF(E3=1,"B","C"))

 

[mustu2]

Thanks a lot!

 

[Arul.rajesh]

=choose(e3+1,"a","b ","c")

 

[jasonb75]

How about

=SUBSTITUTE(ADDRESS(1,E3+1,4),"1","")

That one keeps going if you need it to, 3 = D, 25 = Z, 26 = AA, 16383 =XFD

 

[mustu2]

Thanks everybody for the help.