top of page


Nested IF is a grouping of multiple IF functions that allows us to evaluate multiple conditions.

By incorporating one IF function inside another IF function, we create a Nested IF.

While it is possible to include multiple IF functions within an existing IF function, it is generally recommended to avoid exceeding a total of 3-4 IF statements in order to maintain clarity and simplicity.

The Nested If syntax is: =IF(logical test,value if TRUE,IF(logical test, Value if TRUE, Value if FALSE)

Let's practice witht the following example:

bottom of page