|
| 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
May 17th, 2010, 10:52 PM
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
May 17th, 2010, 10:57 PM
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
May 17th, 2010, 10:58 PM
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
May 18th, 2010, 03:00 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
