ISNAVALUE

Purpose:

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

ISNAVALUE(val)

val

A scalar or series test.

A scalar, series or table.

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

W2: isnavalue(w1)

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

isnavalue(W1) * 100;

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

a = isnavalue(nan);

b = isnan(nan);

a == 1

b == {1}

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.