Function reference
Evaluates a condition and returns a value based on that condition.
If ( boolean, truevalue, falsevalue )
| Argument | Description |
| boolean | A boolean expression that evaluates to true or false |
| truevalue | A string containing the value you want returned if the boolean expression is true |
| falsevalue | A string containing the value you want returned if the boolean expression is false |
Data type: Boolean
Returns truevalue if boolean is true and falsevalue if it is false. Returns null if an error occurs.
Example:
This expression returns 234 if the field value of [MyNumericField] equals 1 – and returns 987 if the value of [MyNumericFiled] equals 0
If ( [MyNumericFiled]=1 , 234 , 987 )
Or
If ( [MyNumericFiled]=1 , ‘My true value’, ‘My false value’ )
Last modified:
23 May 2021