Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested Formula
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Nested Formula
Resolved · Low Priority · Version 2003
Reply Mon 6 Sep 2010, 16:15Delegate Adam said...
Adam has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Nested Formula
How many times can you nest a formula in excel 2003? I heard that an IF statement could be done 7 times max, is this the case for all statements?
Many Thanks
Adam
For upcoming training course dates see: Pricing & availability
RE: Nested Formula
Hi Adam,
A formula can only contain up to 7 levels of nested functions which may include various function types.
When Function B is used as an argument in Function A, Function B is a second-level function. For instance, the AVERAGE function and the SUM function are both second-level functions because they are arguments of the IF function. A function nested within the AVERAGE function would be a third-level function, and so on.
I hope that this helps.
Rodney
Mon 13 Sep 2010: Automatically marked as resolved.
|