If()

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 it does not:

If ( [MyNumericField]=1 , 234 , 987 )

Or, with text values:

If ( [MyNumericField]=1 , 'My true value', 'My false value' )