IF Formula

[Redroc]

I'm needing a formula that will do the following...

If cell A1 is 1 it shows with the word Developing. If A1 is 2 it shows with
the word Performing. If A1 is 3 it shows with the word Leading.

Thanks

 

[Gary Keramidas]

you could put this formula in b1

=CHOOSE(A1,"Developing","Performing","Leading")

 

[Don Guillett]

Look in the help index for IF

 

[Ms-Exl-Learner]

=IF(A1=1,"DEVELOPING",IF(A1=2,"PERFORMING",IF(A1=3,"LEADING","")))