Microsoft Office Tutorials and References

In Depth Information

**Using Nested Functions**

Using Nested Functions

A nested function uses a function as one of the arguments. Excel allows you to nest up

to 64 levels of functions. Users typically create nested functions as part of a conditional

formula. For example, IF(AVERAGE(B2:B10)>100,SUM(C2:G10),0). The AVERAGE

and SUM functions are nested within the IF function. The structure of the IF function is

IF(condition_test, if_true, if_false). You can use the AND, OR, NOT, and IF functions to

create conditional formulas. When you create a nested formula, it can be difficult to un-

derstand how Excel performs the calculations. You can use the Evaluate Formula dialog

box to help you evaluate parts of a nested formula one step at a time.

Create a Conditional Formula Using a Nested Function

Click the cell where you want to enter the function.

Click the
Formulas
tab.

Type
=
(an equal sign).

Click a button from the Function Library with the type of function you want to

use, click a submenu if necessary, and then click the function you want to in-

sert into a formula.