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’ )

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment