nan(
VALUE
)

The nan( function checks to see if a numeric value is invalid.


Parameters

This function has one parameter:

value – floating point value or expression


Description

This function checks to see if a value is an invalid number. (The function name *nan(* stands for not a number). What is an invalid number, you ask? Some examples would include anything divided by zero or the square root of a negative number.

nan(5/2) ☞ false
nan(5/0) ☞ true
nan(sqr(8)) ☞ false
nan(sqr(-8)) ☞ true

Note: The nan( function is the opposite of validnumber(, which returns true if the value is valid, false if it is invalid.


See Also


History

VersionStatusNotes
10.0NewNew in this version