Nesting is the technique 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.
In other words, the general concept of nesting is that the "outer" formula is doing something useful and the "inner" formula is providing something the "outer" formula needs to do the job. Usually, the inner function(s) make it possible to avoid hard-coding information into the "outer" function, since hard-coding makes a formula less useful and portable.
Example
In the example shown, the formula in D4 uses nesting to calculate the current age of a person based on their birthdate:
=INT(YEARFRAC(C4,TODAY()))
In this formula, 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:
