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 (G2:G5) only if the average of another set of numbers (C2:C6) is greater than 100. Otherwise it returns 0.

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

The function '=LEFT(B1,FIND(" ",B1)-1)' shown in the training video extracts the first name from a full name by nesting the 'find' function in the 'left' function.