Name

isnan — Test if a value represents an invalid value (Not A Number).

Syntax

isnan(number)
                

The ISNAN function has the following arguments:

number

The double value which you want to test for an invalid value.

Description

The isnan function will test if the input value represents an invalid value.

Invalid values may result from some types of calculations.

Examples

Formula

Description

Result

isnan(1.0)

Test if 1.0 is an invalid value

false

isnan(sqrt(-1))

Test if sqrt(-1) is an invalid value

true