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:
When you enter =IF(A1>10;"red";IF(A1>5;"yellow";IF(A1>2;"green";"black"))) you receive the following: