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
|
|||
|
|||
what is the max no. of nested Ifs can an If Statements have in EXC
and how does one get around this limitation
|
#2
|
|||
|
|||
Hi StevenE
The alleged limitation is 7. It is easy to overcome though. Try and use lookup, iso IF. You can also split your argument into more than one column, of which each can have 7 levels, but this is the long route, and dates back to before Office, when Lotus 123 was the in thing You can also use arrays "StevenE" wrote: and how does one get around this limitation |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to write a nested loop using sql cursors | Paul | Using Forms | 3 | January 12th, 2005 01:13 PM |
passing data from a Form to a nested Form at deep 3 | Tran | Using Forms | 2 | December 23rd, 2004 05:02 PM |
Nested tables | david | Database Design | 1 | October 13th, 2004 09:02 AM |
Excel XP Nested If Function Problem | DaffyD® | Worksheet Functions | 2 | March 6th, 2004 06:46 PM |
nested formula help needed | Worksheet Functions | 0 | October 14th, 2003 04:17 PM |