| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula
you could put this formula in b1
=CHOOSE(A1,"Developing","Performing","Leading") -- Gary Keramidas Excel 2003 "Redroc" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula
Look in the help index for IF
-- Don Guillett Microsoft MVP Excel SalesAid Software "Redroc" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula
=IF(A1=1,"DEVELOPING",IF(A1=2,"PERFORMING",IF(A1=3 ,"LEADING","")))
-- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Redroc" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
