IF
Description
Evaluates a logical condition. If TRUE, returns value_if_true. If FALSE, returns value_if_false_optional (if provided); otherwise returns $SKIP_ASSIGNMENT.
Syntax
IF(...[logical_test, value_if_true], value_if_false_optional) -> Object
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| … logical_test | Boolean | Yes | The condition to evaluate. |
| … value_if_true | Object | Yes | The value returned when the condition is TRUE. |
| value_if_false_optional | Object | No | The value returned when the condition is FALSE. |
Examples
IF(1 > 2, "A", "B")
-- Returns "B".IF(1 > 2, "A")
-- Returns $SKIP_ASSIGNMENT.IF(Probability > 80, "High",
Probability > 40, "Medium",
"Low")
-- Returns "High" if Probability > 80.
-- Returns "Medium" if Probability > 40.
-- Otherwise, returns "Low".