If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|