isnan
isnan(number)
The ISNAN function has the following arguments:
numberThe double value which you want to test for an invalid value.
The isnan function will test if the input value represents an invalid value.
Invalid values may result from some types of calculations.
|
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 |