Main Page 
PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
nested ifs
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
nested ifs
 |
nested ifs |
|
|
Thread Tools | Rate Thread |
15-12-2004, 02:29 PM
|
#1 |
|
Guest
Posts: n/a
|
nested ifs
since excel has a limit of 7 nested ifs and someone i know needs to do 12
nested ifs is there a way to do this |
|
|
15-12-2004, 06:38 PM
|
#2 |
|
Guest
Posts: n/a
|
Re: nested ifs
Depends upon what the data looks like, but you should be able to use LOOKUP
or VLOOKUP where the test values and lookup values are defined in a table. -- HTH RP (remove nothere from the email address if mailing direct) "sthompson" <sthompson@discussions.microsoft.com> wrote in message news:55C658D9-8CCA-43F2-AB85-89FC8F7B8A00@microsoft.com... > since excel has a limit of 7 nested ifs and someone i know needs to do 12 > nested ifs is there a way to do this |
|
|
|
|
| Thread Tools | |
| Rate This Thread | |
|
|
