Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum IF Statements in a Formula
Excel HELP seems to indicate that the maximum number of IF statements in a
formula is seven. I have successfully designed formulas with 12 IF statements. I am wondering just what the limits are? I have written a formula exceeded the limits on the number of characters in a formula. I suspect that limit might be 1,000 characters. If anyone knows the limit on the number of characters in a formula, I would be interested in that limit too. -- eeldav |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum IF Statements in a Formula
You are limited to 7 IF statements if they are nested within each other.
However, you can have more if one of your IF statements branches off into two lines of logic, each of those having IF statements. -- Best Regards, Luke Moraga "eeldav" wrote: Excel HELP seems to indicate that the maximum number of IF statements in a formula is seven. I have successfully designed formulas with 12 IF statements. I am wondering just what the limits are? I have written a formula exceeded the limits on the number of characters in a formula. I suspect that limit might be 1,000 characters. If anyone knows the limit on the number of characters in a formula, I would be interested in that limit too. -- eeldav |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum IF Statements in a Formula
Luke Moraga has explained the limitation on IF limits accurately. It should
be noted that this limit for NESTED functions is not just for IF, but for all nested functions, even a mixture. The formula limit in Excel 2003 is 1024 characters. You can find the exact limits for these kinds of things in Excel Help. Do a search for either Excel Specifications or for Excel Specifications and Limits ... both should lead you to the same place in Help. "eeldav" wrote: Excel HELP seems to indicate that the maximum number of IF statements in a formula is seven. I have successfully designed formulas with 12 IF statements. I am wondering just what the limits are? I have written a formula exceeded the limits on the number of characters in a formula. I suspect that limit might be 1,000 characters. If anyone knows the limit on the number of characters in a formula, I would be interested in that limit too. -- eeldav |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not More Than or Maximum in a formula | Excel Discussion (Misc queries) | |||
Return Maximum from Column directly above Maximum in Row | Charts and Charting in Excel | |||
maximum formula | Excel Discussion (Misc queries) | |||
What is the maximum formula lenght?? | Excel Discussion (Misc queries) | |||
Maximum of a formula | Excel Worksheet Functions |