Nested IF

Explanation

Nested IF is a combination of more than one IF function which can help us check multiple conditions.

IF function recap: IF function returns one value if a statement is TRUE, and another value if a statement is FALSE.

When we add one IF function within another IF function we create a Nested IF.

We can insert multiple IF functions within existing IF function, but we advise not use more than 3-4 IF statements altogether.

Syntax

Hereinafter an example of an IF statement under the “value if FALSE” argument:

=IF(logical test,value if TRUE,IF(logical test, Value if TRUE, Value if FALSE)

Hereinafter an example of an IF statement under “value if the TRUE” argument:

=IF(logical test,IF(logical test, Value if TRUE, Value if FALSE), value if FALSE)

Practice Nested IF function

Now, let’s try to practice Nested IF function: