ISERR function

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

Description

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

Syntax

ISERR(value)

The ISERR 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.

Note

  • This function returns 1 for true or 0 for false. These show as true or false in a Boolean field.

Example

Table 1. Data
N1 N2
5 4
5 0
Formula Description Result (Boolean field) Result (Integer field)
ISERR([N1]/[N2]) Normal division. false 0
ISERR([N1]/[N2]) Divide by zero error. true 1