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 TutorialThe 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.

Excel Nested Function TutorialThis 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 Nested Function TutorialThis 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.

Excel Nested Function TutorialThis tutorial includes an example of nesting the OR function inside the IF function.

Excel Nested Function TutorialThis tutorial includes an example of nesting the AND function inside the IF function.

Excel Nested Function TutorialIn 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 Nested Function TutorialSimilar to the MIN IF tutorial above, except this formula finds the largest or maximum value in a selected range.

Excel Nested Function TutorialSimilar 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.

Excel Nested Function TutorialThis 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 Nested Function TutorialThis 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.