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.
Search JabSto ::




Custom Search