Scribd
Upload
9 views6 pages

Understanding Nested Functions in Excel

Jennifer Ventus, SMIT-CA NESTED FUNCTIONS Functions can be used as arguments for other functions. In nested function, the user can also use the same functions for the primary and the secondary functions. A formula can contain up to seven levels of nested functions. Example: =IF(D2<=74,´FAILED´,VLOOKUP(D2,Grade,3)) Take note of the open and close parenthesis, no IF function is the primary used in nested function matter how many functions function,athen inside its arguments is another func

Uploaded by

irish x
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd
9 views6 pages

Understanding Nested Functions in Excel

Jennifer Ventus, SMIT-CA NESTED FUNCTIONS Functions can be used as arguments for other functions. In nested function, the user can also use the same functions for the primary and the secondary functions. A formula can contain up to seven levels of nested functions. Example: =IF(D2<=74,´FAILED´,VLOOKUP(D2,Grade,3)) Take note of the open and close parenthesis, no IF function is the primary used in nested function matter how many functions function,athen inside its arguments is another func

Uploaded by

irish x
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPT, PDF, TXT or read online on Scribd

Jennifer Ventus, SMIT-CA

NESTED FUNCTIONS

Functions can be used as arguments for other


functions.

In nested function, the user can also use the


same functions for the primary and the secondary
functions.

A formula can contain up to seven levels of


nested functions.
Example:

=IF(D2<=74,”FAILED”,VLOOKUP(D2,Grade,3))
Take note of the open and close parenthesis, no
IF function
matter is the functions
how many primary function,
used in a then inside
nested its
function
arguments is remember
formula, always another function,
that each which
functionismust
the
VLOOKUP
have its ownfunction.
open and close parenthesis.
Example 2:

Determine the Penalty Amount. Output NONE if the


Total Days due is less than or equal to 7 days.
Total Days due of more than 15 days would
automatically get a penalty amount of 200.00
IF(I6<=7,"none",IF(I6>=15,200,VLOOKUP(I6,penalties1,2)))

Penalties1 Table
IF(I6<=7,"none",IF(I6>=15,200,VLOOKUP(I6,penalties1,2)))

Where “d” represents Days.


=DATEDIF(D6,TODAY(),"d") Datedif may also be used to
determine a person’s age by
simply changing “d” to “y”

You might also like