IF
Syntax
IF (condition, TrueValue, FalseValue)
Description
Returns one value if the specified condition evaluates to True, and another value if that condition evaluates to False.
Arguments
| condition | A logical expression or statement that can be evaluated to Boolean True or False. |
| TrueValue | The value, of any data type, to return if condition evaluates to True. |
| FalseValue | The value, of any data type, to return if condition evaluates to False. |
Returns
If condition evaluates to True, returns the value of TrueValue.
If condition evaluates to False, returns the value of FalseValue.
Remarks
You can combine IF and other math functions with arithmetic operators. See Formula Editor Operators.
Example
If MyEntity.Name might contain the value ACME Software, then the following formula:
IF(MyEntity.Name = "ACME Software", MyEntity.Name, "Not ACME")
Returns:
— "ACME Software" if it exists in the source field.
— "Not ACME" if ACME Software is not in the source field.