Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting level limits
How come a formula can only contain up to seven levels of nested
functions.... I need more than this, maybe 10 upwards..., how can I get around this problem? It seems a ridiculous limit seeing as Excel is a programme driven by a computer which can cope with thousands and thousands of formulae and functions! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting level limits
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting level limits
Also, you could use a defined name for part of your function
Click insert/names/define, in the refers to box type the piece of your larger function you want represented by name. For example NamedFunction = IF(AND(Condition1, Condition2), VLookup(Arg1, Arg2, Arg3, Arg4), "") Then, I could replace the IF statement in my larger function with the name, NamedFunction and save 2 levels of nested function calls. "DJ Magic" wrote: How come a formula can only contain up to seven levels of nested functions.... I need more than this, maybe 10 upwards..., how can I get around this problem? It seems a ridiculous limit seeing as Excel is a programme driven by a computer which can cope with thousands and thousands of formulae and functions! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Ranking Pre-Set Limits | Excel Discussion (Misc queries) | |||
turning student scores into a level??? | Excel Worksheet Functions | |||
Function that gives Group level? | Excel Worksheet Functions | |||
How can I increas undo level in Microsoft EXCEL ? | Excel Discussion (Misc queries) | |||
How do i set up if function with more than level limits? | Excel Worksheet Functions |