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: