Skip to main content
Version: Streamsheets 2.4

IF

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

Syntax

=IF(Condition [, TrueValue, FalseValue ])

Arguments

NameDescription
ConditionCondition to check.
TrueValueOptional value to return, if the condition is true. If not specified nothing is returned.
FalseValueOptional value to return, if the condition is false. If not specified nothing is returned.

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.