IfFinite

Qubes 6.8 Returns the first parameter that is a finite number.

Syntax

IfFinite(param1, param2, ...)
param1 = first value to check
param2 = second value to check
... = nth value to check

Remarks

This function can accept 1 to 99 parameters.
It applies the same rules as the IsFinite function.

See also IfError, coalescing operator.

Examples

IfFinite("hello", 0) = 0
IfFinite("#VAL!", "#ERR!", 0) = 0
IfFinite(1/0, 0) = 0
IfFinite(1, 0) = 1

Classification

Logic