Skip to main content

IF

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

Syntax

=IF(Condition, TrueValue, FalseValue)

Arguments

NameDescription
ConditionCondition to check.
TrueValueThe value to return, if the condition is true.
FalseValueThe value to return, if the condition is false.

Return Value

The appropriate value depending on the condition.

Example

FunctionResultComment
=IF(3>1, "Warning", "OK")"Warning"As the condition results to TRUE, the first value is returned.