How to Create Nested IF Statements

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