Using a function as one of the arguments in a formula that uses a function is called nesting, and we'll refer to that function as a nested function.

Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a …

When you combine each one of them with an IF statement, they read like this: Following are examples of some common nested IF (AND ()), IF (OR ()) and IF (NOT ()) statements in Excel.

For example, the AVERAGE function and the SUM function are both second-level functions if they are used as arguments of the IF function. A function nested within the nested AVERAGE function is then …

When you need to find data that meets more than one condition, such as units sold between April and January, or units sold by Nancy, you can use the AND and OR functions together. Here's an example:

The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much …

With the Evaluate Formula dialog box, you can see how a nested formula calculates its result by inspecting its intermediate calculations and logical tests.

Example 5 uses a nested XLOOKUP function to perform both a vertical and horizontal match. It first looks for Gross Profit in column B, then looks for Qtr1 in the top row of the table (range C5:F5), and …

How to use the IF function in Excel to make logical comparisons between data values.

Excel can't calculate an array within an array. The nested array error occurs when you try to input an array formula that contains an array. To resolve the error, try removing the second array.

Explore how-to articles, guides, training videos, and tips to efficiently use Excel.