IF

Use the IF function to return one value if a condition is TRUE and another value if it's FALSE.

Use

IF( condition, value_if_true, value_if_false )
Returns the first value if the logical condition is TRUE otherwise return the second value.

Parameter	Required	Description
condition	Yes	the logical condition to evaluate
value_if_true	Yes	the value to return if the logical condition is TRUE
value_if_false	Yes	the value to return if the logical condition is FALSE

Returns

A value with the same type as value_if_true

Example

This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.