Exceljet

Quick, clean, and to the point

Nesting

Example of nesting in an Excel formula

Nesting is the practice of placing one formula or function inside another.  The idea is that one function requires a value that can be delivered by another. By nesting a function inside another, and placing the inner function where a function argument would appear, the inner function can pass a result directly to the outer function.

Example

In the example shown, the formula in D4 contains three functions that are nested:

The TODAY function is nested inside of the YEARFRAC function, which is nested inside the INT function. The TODAY function returns the current date, which is passed into the YEARFRAC function as the "end date". The start date is provided by cell C4. YEARFRAC returns a decimal value like this in D4:

18.425 // YEARFRAC result on Oct 19, 2019

whis is passed directly the INT function. The INT function removes the decimal portion of the number and returns 18 as a final result.

More examples of nesting

Nesting is a common technique in more advanced Excel formulas. Here are a few more examples: