IF Formula
in [General]
|
From: Redroc on 17 May 2010 17:52 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
From: Gary Keramidas on 17 May 2010 17:57 you could put this formula in b1 =CHOOSE(A1,"Developing","Performing","Leading") -- Gary Keramidas Excel 2003 "Redroc" <Redroc(a)discussions.microsoft.com> wrote in message news:7C464B73-6438-4BD7-8002-DC494926E073(a)microsoft.com... > 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
From: Don Guillett on 17 May 2010 17:58 Look in the help index for IF -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Redroc" <Redroc(a)discussions.microsoft.com> wrote in message news:7C464B73-6438-4BD7-8002-DC494926E073(a)microsoft.com... > 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
From: Ms-Exl-Learner on 17 May 2010 22:00 =IF(A1=1,"DEVELOPING",IF(A1=2,"PERFORMING",IF(A1=3,"LEADING",""))) -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Redroc" <Redroc(a)discussions.microsoft.com> wrote in message news:7C464B73-6438-4BD7-8002-DC494926E073(a)microsoft.com... > 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
|
Pages: 1 Prev: Conditional Formatting Multiple Cells Next: I need help with a macro please! |