An IF statement in Excel evaluates a condition and returns a value based on a true or false outcome. Nested IF statements allow testing multiple conditions within a single formula.

Nested IF Statement If you want to test multiple conditions simultaneously, you can place IF statements inside another. These are called nested IF statements, and their basic syntax is: ...