IF

If condition

Description

If the first parameter evaluates to true, returns the second parameter. Otherwise, returns the third parameter.

Function signature

IF(condition: Boolean, truevalue: , falsevalue: ) => String

Parameter

Description

Condition

Value deciding the return value

True value

Returned if the first parameter is truthy

False value

Returned if the first parameter is falsy

Examples

Formula

Return value

IF(true, "yes", "no")

yes

IF(false, "yes", "no")

no