Description

Conditional return

Syntax

IF(n1, v2)

●      n1: numeric (Boolean value)

●      v2: return value if n1 is non-zero

Example

IF(Verified, Price)     If Verified is TRUE (or non-zero)   ® Price

                              otherwise                                  ® NULL

Note

Do not compare a Boolean field to its TRUE value, just use it as the value. In other words: IF(field, v2) rather than IF(field=TRUE, v2)