Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA
as above, what is the max number of "if" conditions available in one formula?
i cannot seem to add more than 8?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA
Hi
What are you trying to achieve? The maximum level of nesting in XL2003 and earlier if 7, but has been increased to 256 in XL2007. This limit can be overcome for IF statements, by concatenating as many sets of 7 IF's with the "&" operator. =(first set of 7)&(second set of 7)&(third set of 7) etc. However, using even 7 levels of IF can become very unwieldy and difficult to maintain, and there are usually better solutions available using LOOKUP, VLOOKUP, CHOOSE etc. Post details of what you are trying to achieve, and someone will be able to propose an alternative solution for you. -- Regards Roger Govier "gallie" wrote in message ... as above, what is the max number of "if" conditions available in one formula? i cannot seem to add more than 8?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA | Excel Worksheet Functions | |||
WHAT IS THE MAX NUMBER OF "IF" CONDITIONS POSSIBLE IN ONE FOUMULA | Excel Worksheet Functions | |||
Syntax to "OR" 3 "ISERROR" conditions | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |