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.
See ANYNAN to determine if the input or any element of the input is NaN.