ISNA function

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

Description

Returns TRUE if the value is the #N/A error value.

Syntax

ISNA(value)

The ISNA function syntax has the following argument:

value Required. The value that you want tested. The value argument can be a blank (empty field), error, logical value, text, number, or reference value, or a column reference referring to any of these.

Example