ISNAVALUE

Purpose:

Returns data of the same type as its input, with ones wherever the input is NaN, zeros elsewhere.

Syntax:

ISNAVALUE(val)

val

-

A scalar or series test.

Returns:

A scalar, series or table.

Example:

W1: {3, 6, 9, 12, nan, 15, 18}

W2: isnavalue(w1)

 

W2 contains the series {0, 0, 0, 0, 1, 0, 0}.

Example:

isnavalue(W1) * 100;

 

generates a series with a 100 where there is an NaN and 0 otherwise.

Example:

a = isnavalue(nan);

b = isnan(nan);

 

a == 1

b == {1}

Remarks:

Unlike ISNAN, ISNAVALUE returns a scalar for a scalar input.

 

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

 

Use NAN or NAVALUE to create an NaN value.

See Also:

ISINF

ISNAN

NAFILL

NAN

NAVALUE

READTABLE

REMOVENA

SETNAVALUE