IF Operation

How to use the IF operation for Computed Attributes

Definition

The IF operation returns a value based on a set of conditions.

Example

IF(EQ(1, 1), ‘equal’, ‘different’)

Result:
equal

Syntax Guide

IF(logical_expression, value_if_true, value_if_false)

logical_expression - An expression that represents some logical value, i.e. TRUE or FALSE

value_if_true - The value the function returns if logical_expression is TRUE

value_if_false - [ OPTIONAL - blank by default ] - The value the function returns if logical_expression is FALSE