How to Create Nested IF Statements

Gido

Goal

Create nested IF statements in a workbook.

Learn

The IF function has the following syntax:

IF( <this is #true>; <then #do()>; <else #do()>)

As each argument can contain every function, which means also an IF, a nested statement would look like:

IF( <this is #true>; 
    IF( <this is #true>; <then #do()>; <else #do()>); 
    IF( <this is #true>; <then #do()>; <else #do()>)
  )

Noe that the line breaks are included for readability, and they are not necessary in the workbook.

Further Information

Use the IF function for an IF THEN ELSE Statement