How to Use Nesting Functions in Excel

In this tricks we will teach you with the tricks to Use Nesting Functions in Excel. Nested functions are best entered directly. The Insert Function dialog box does not make it easy to enter a nested function. Try one. In this example, you use the AVERAGE function to find the average of the largest values from two sets of numbers. The nested function in this example is MAX. You enter the MAX function twice within the AVERAGE function. (Nesting Functions in Excel)

About Microsoft Excel: (Nesting Functions in Excel)

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Step by Steps Guide to use Nesting Functions in Excel

Step 1:
Enter a few different numbers in one column.

Step 2:
Enter a few different numbers in a different column.

Step 3:
Click an empty cell where you want the result to appear.

Step 4:
Type =AVERAGE( to start the function entry.

Step 5:
Type MAX(.

Step 6: (Nesting Functions in Excel)
Click the first cell in the second set of numbers, press the mouse button, and drag over all the cells of the first set.

Step 7:
The address of this range enters into the MAX function.

Step 8:
Enter a closing parenthesis to end the first MAX function.

Step 9:
Enter a comma (,).

Step 10: (Nesting Functions in Excel)
Once again, type MAX(.

Step 11:
Click the first cell in the second set of numbers, press the mouse button, and drag over all the cells of the second set.

Step 12:
The address of this range enters into the MAX function.

Step 13:
Enter a closing parenthesis to end the second MAX function.

Step 14 (Nesting Functions in Excel)
Enter a ).

This ends the AVERAGE function.

Step 15.
Press Enter.