Excel Nested IF Function with AND

A nested function uses a function as one of the arguments. Excel allows you to nest up to 64 levels of functions. Users typically create nested functions as part of a conditional formula. This example demonstrates how using IF and AND function.