IF function

This topic describes the formula syntax and usage of the IF function in the Data Quality Execute Formula transform.

Description

Specifies a value returned if an expression is true or false.

Syntax

IF(logical_expression,value_if_true,value_if_false)
  • logical_expression The logical expression to be evaluated by the IF statement.
  • value_if_true The value, reference, or expression if True.
  • value_if_false The value, reference, or expression if False.

Example

The following returns "Solvent" if the value in the AccountBalance field is greater than or equal to zero or "Insolvent" if the value is less than zero.

IF([AccountBalance]>=0,"Solvent","Insolvent")