An IF statement has this syntax: IF(condition, then, else). These placeholders are used:
THEN — Represents the outcome if the CONDITION is true. This could be the use of a different value or calculation.
CONDITION — Represents criteria that must be true for an outcome to occur. If the condition is true, the outcome you define for THEN is used. You can use multiple conditions. If the condition is false, the outcome you define for ELSE is used
ELSE — Represents another outcome to use if the outcome you define for THEN is false.