IF

Checks a condition and returns a value depending on the result.

IF requires three arguments. The input is entered in the following form:

IF(Condition;Condition met;Condition not met).

Example

When you enter =IF(A1>A2;1;0) you receive TRUE.

When you enter =IF(A1>A2;TRUE;FALSE) you receive the following:

IF

When you enter =IF(A1>10;"red";IF(A1>5;"yellow";IF(A1>2;"green";"black"))) you receive the following:

IF