| | |
| |||||||
| Forums | Register | Groups | Awards | Arcade | Pets | T-Bucks / T-Store | Invite Your Friends | Blogs | Mark Forums Read |
| Microsoft Applications Discussions about Windows and other MS Products such as Office |
 |
| | LinkBack | Thread Tools |
12-01-2004, 16:00
| #1 (permalink) |
| Civilians |  Nest IF alternative? This is probably easy, but I don't have a lot of time to think about it right now. I know you guys will know this. I'd like to write a formula that in a long format would use nested IF statements. I'm sure there would be an easier way. What I'd like to do is: In cell A2: =IF(A1="A",A1,IF(A1="B",A1,IF(A1="C",A1,A3))) Is there an easier way to write this? Thanks, Paul |
     |
| Trackpads Information |
| |
|
12-01-2004, 16:00
| #2 (permalink) |
| Civilians | Re: Nest IF alternative? Sorry about your lack of time. Of course, we all have a lot of time to do your work. -- Don Guillett SalesAid Software donaldb@281.com "PCLIVE" <pclive@livenet.net> wrote in message news:%23uymPY91EHA.412@TK2MSFTNGP14.phx.gbl... > This is probably easy, but I don't have a lot of time to think about it > right now. I know you guys will know this. > > > I'd like to write a formula that in a long format would use nested IF > statements. I'm sure there would be an easier way. What I'd like to do is: > > In cell A2: > =IF(A1="A",A1,IF(A1="B",A1,IF(A1="C",A1,A3))) > > Is there an easier way to write this? > > Thanks, > Paul > > |
| |
|
12-01-2004, 16:00
| #3 (permalink) |
| Civilians | RE: Nest IF alternative? One way =IF(OR(A1={"A","B","C"}),A1,A3) Regards, Peo Sjoblom "PCLIVE" wrote: > This is probably easy, but I don't have a lot of time to think about it > right now. I know you guys will know this. > > > I'd like to write a formula that in a long format would use nested IF > statements. I'm sure there would be an easier way. What I'd like to do is: > > In cell A2: > =IF(A1="A",A1,IF(A1="B",A1,IF(A1="C",A1,A3))) > > Is there an easier way to write this? > > Thanks, > Paul > > > |
| |
|
12-01-2004, 16:00
| #4 (permalink) |
| Civilians | Re: Nest IF alternative? If you don't know, then just say so and I'll just give my thanks to PEO. Apparently you've been doing this a little too long and need to take a breather. Thank you anyway for your effort. Best regards, Paul "Don Guillett" <donaldb@281.com> wrote in message news:uoiZ%23r91EHA.1292@TK2MSFTNGP10.phx.gbl... > Sorry about your lack of time. Of course, we all have a lot of time to do > your work. > > -- > Don Guillett > SalesAid Software > donaldb@281.com > "PCLIVE" <pclive@livenet.net> wrote in message > news:%23uymPY91EHA.412@TK2MSFTNGP14.phx.gbl... >> This is probably easy, but I don't have a lot of time to think about it >> right now. I know you guys will know this. >> >> >> I'd like to write a formula that in a long format would use nested IF >> statements. I'm sure there would be an easier way. What I'd like to do > is: >> >> In cell A2: >> =IF(A1="A",A1,IF(A1="B",A1,IF(A1="C",A1,A3))) >> >> Is there an easier way to write this? >> >> Thanks, >> Paul >> >> > > |
| |
|
12-01-2004, 16:00
| #5 (permalink) |
| Civilians | Re: Nest IF alternative? Thank you for not taking my words so literal. In no way do I think my time is more valuable than someone elses. You've been most helpful. Works Great! I was on the right track, but wouldn't have thought of using the {}. Thanks again, Paul "Peo Sjoblom" <PeoSjoblom@discussions.microsoft.com> wrote in message news:91B2568C-B4E2-4AD6-960D-564DD83A3286@microsoft.com... > One way > > =IF(OR(A1={"A","B","C"}),A1,A3) > > > Regards, > > Peo Sjoblom > > > "PCLIVE" wrote: > >> This is probably easy, but I don't have a lot of time to think about it >> right now. I know you guys will know this. >> >> >> I'd like to write a formula that in a long format would use nested IF >> statements. I'm sure there would be an easier way. What I'd like to do >> is: >> >> In cell A2: >> =IF(A1="A",A1,IF(A1="B",A1,IF(A1="C",A1,A3))) >> >> Is there an easier way to write this? >> >> Thanks, >> Paul >> >> >> |
| |
|
12-01-2004, 19:00
| #6 (permalink) |
| Civilians | Re: Nest IF alternative? I know the answer but didn't like your attitude. -- Don Guillett SalesAid Software donaldb@281.com "Don Guillett" <donaldb@281.com> wrote in message news:uoiZ%23r91EHA.1292@TK2MSFTNGP10.phx.gbl... > Sorry about your lack of time. Of course, we all have a lot of time to do > your work. > > -- > Don Guillett > SalesAid Software > donaldb@281.com > "PCLIVE" <pclive@livenet.net> wrote in message > news:%23uymPY91EHA.412@TK2MSFTNGP14.phx.gbl... > > This is probably easy, but I don't have a lot of time to think about it > > right now. I know you guys will know this. > > > > > > I'd like to write a formula that in a long format would use nested IF > > statements. I'm sure there would be an easier way. What I'd like to do > is: > > > > In cell A2: > > =IF(A1="A",A1,IF(A1="B",A1,IF(A1="C",A1,A3))) > > > > Is there an easier way to write this? > > > > Thanks, > > Paul > > > > > > |
| |
|
| Bookmarks |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Empty nest syndrome | scotto | Chit-Chat | 1 | 05-03-2007 16:43 |
| Re: One Nest Too Many - Help! | Harlan Grove | Microsoft Applications | 1 | 09-23-2005 20:00 |
| Re: One Nest Too Many - Help! | smd111 | Microsoft Applications | 1 | 09-23-2005 16:00 |
| This aughta get the traditionalist hornets nest stirring | Robert R Kircher, Jr. | Auto Racing | 35 | 09-12-2005 04:00 |
| [News Feed] Migrant Stumbles Into U.S. Militia 'Hornet's Nest' | Forum Mouse | News Articles | 0 | 04-03-2005 22:00 |
 |  |  |
