IsFinite

Qubes 6.8 Returns True if the parameter is a finite number.

Syntax

IsFinite(val)
val = the value to check if it is a finite number

Remarks

If the value entered as a parameter is not a number, or if it is NaN, Infinity or -Infinity, the function will return False.

Note that if val is a non-empty string, an implicit conversion to a number will be attempted.

See also IsError.

Examples

IsFinite("#VAL!") = False
IsFinite("hello") = False
IsFinite("2") = True
IsFinite(2) = True
IsFinite(2/0) = False
IsFinite(0/0) = False

Classification

Logic