AND function

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

Description

Returns Boolean true if all of its arguments are TRUE.

Syntax

AND(logical_expression1,logical_expression2,...)

The AND function syntax has the following arguments:

logical_expression1,logical_expression2,... Series of logical expressions that evaluate to TRUE or FALSE.

Example

Data: Values less than 100 in the Tens field, values greater than 100 and less than 1000 in the Hundreds field, and values greater than 1000 in the Thousands field.


Formula	Description	Result
`AND([Tens]<100,[Hundreds]>100)`	Both expressions TRUE	true
`AND([Tens]<100,[Hundreds]<100)`	First expression TRUE, second expression FALSE	false
`AND([Tens]<100,[Hundreds]>100,[Thousands]>1000)`	Three TRUE expressions	true