ISNAN

Purpose:

Returns 1 for each element that is a NaN value.

Syntax:

ISNAN(series)

series

-

A series to test.

Returns:

A series where each element is 1 where the input series is an NaN value and 0 where the input series is not an NaN value.

Example:

a = {1, 2, inf, nan};

b = 5;

c = {};

 

isnan(a) == {0, 0, 0, 1}

isnan(b) == {0}

isnan(c) == {}

Example:

a = isnavalue(nan);

b = isnan(nan);

 

a == 1

b == {1}

Remarks:

Unlike ISNAVALUE, ISNAN always returns a series.

 

ISNAN returns an empty series if the input is an empty series.

 

Use NAN or NAVALUE to create an NaN value.

See Also:

FINITE

INF

ISEMPTY

ISINF

ISNAVALUE

NAFILL

NAN

REMOVENA

SETNAVALUE