IF functions can be either isolated, meaning that only one condition is applied to your data, or nested, where multiple criteria are applied to generate a TRUE or FALSE result. Isolated IF function.

So, in our example above, ... As the name suggests, a nested IF function is where there is an IF function inside an IF function. Let me explain how these work with an example.