98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Nested Formula
Nested Formula
Resolved · Low Priority · Version 2003
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
Mon 6 Sep 2010, 20:43Trainer Rodney said...
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.
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. |
Excel tip:Remove unused toolbar buttonsAre there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following: |
