Nested Functions in Excel

Nested Functions in Excel 2007
Nested functions use a function as one of the arguments of another function. You can nest up to 64 levels of functions in Excel 2007. In Excel 2003 you could nest only uto 7 levels under normal working conditions. The following formula sums a set of numbers (D2:D6) only if the average of another set of numbers (C2:C6) is greater than 100. Otherwise it returns 0 or blank.

=IF(SUM(C2:C6)>100,AVERAGE(D2:D6),0)
The AVERAGE and SUM functions are nested within the IF function.

Nested Functions in Excel

Nested Functions in Excel

Nested If functions have proven to be useful in many situations.
Watch the training video below to see how nested function in Excel are implemented.

Further reading:
Nested functions in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *