IF

Returns depending on the condition the true or the false argument.

Syntax

=IF(Condition, TrueValue, FalseValue)

Arguments

Name

Description

Condition

Condition to check.

TrueValue

The value to return, if the condition is true.

FalseValue

The value to return, if the condition is false.

Return Value

The appropriate value depending on the condition.

Example

Function

Result

Comment

=IF(3>1, “Warning”, “OK”)

“Warning”

As the condition results to TRUE, the first value is returned.