1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Nested Functions in Excel

Excel Nested Function Tutorials

By

A nested function in Excel refers to one or more  function being placed inside another. This is done to extend the capabilities of a function. How it works is that the nested functions are used as arguments of the first function. These tutorials include step by step examples of using nested functions in Excel.

Excel Nested IF Function Step by Step Tutorial

Excel Nested IF Function Tutorial
Excel Nested IF Function Tutorial

The usefulness of the IF function can be extended by using one or more Nested IF functions.

Nested IF functions increase the number of possible outcomes that can be tested for and increase the number of actions that can be taken to deal with these outcomes.

This step by step tutorial used nested IF functions to determine the deduction rate for employees based on their annual salary.

Lookup Formula with Multiple Criteria in Excel

Excel Nested Function Tutorial
Excel Nested Function Tutorial
This tutorial nests the INDEX and MATCH functions to create a lookup formula that will use multiple criteria when finding information in a table of data. This formula can be used in place of VLOOKUP or HLOOKUP which only allow for a single criterion.

Excel Two Way Lookup Using VLOOKUP

Excel Nested Function Tutorial
Excel Nested Function Tutorial
This tutorial nest the MATCH and VLOOKUP functions to create a two-way or two-dimensional lookup formula. The formula allows you to find the information located at the intersection point for rows and columns of data.

Nested OR and IF Function Tutorial

Excel Nested Function Tutorial
Excel Nested Function Tutorial

This tutorial includes an example of nesting the OR function inside the IF function.

Nested AND and IF Function Tutorial

Excel Nested Function Tutorial
Excel Nested Function Tutorial

This tutorial includes an example of nesting the AND function inside the IF function.

Excel MIN IF Array Formula Tutorial

Excel Nested Function Tutorial
Excel Nested Function Tutorial
In addition to using nested MIN and IF functions, an array formula is also used. The entire formula allows you to find the smallest value in a list of data that meets a specified condition.

Excel MAX IF Array Formula Tutorial

Excel Nested Function Tutorial
Excel Nested Function Tutorial
Similar to the MIN IF tutorial above, except this formula finds the largest or maximum value in a selected range.

Excel MEDIAN IF Array Formula Tutorial

Excel Nested Function Tutorial
Excel Nested Function Tutorial
Similar to the MIN IF and MAX IF tutorials above, except this formula finds the middle value in a selected range using the MEDIAN and IF functions.

Nested ROUND and SUM Function Tutorial

Excel Nested Function Tutorial
Excel Nested Function Tutorial

This step by step tutorial uses a nested SUM function with the ROUND function. The example rounds off the result of an addition operations to two decimal places.

Excel Rolling Dice Tutorial

Excel Nested Function Tutorial
Excel Nested Function Tutorial

This tutorial takes you through all the steps necessary to create a dice roller program in Excel.  Depending on the random numbers generated by the RANDBETWEEN functions, dots will appear in the appropriate cells of the dice in the worksheet. A combination of nested IF, AND, and OR functions control when dots appear in each cell of the dice.

©2014 About.com. All rights reserved.