OUTOFRANGE function

Synopsis
This function returns whether the specified number is outside the range of the specified bounds.
Variations
OUTOFRANGE(Number, LowBound, HighBound)
Returns whether the function is outside the range of the specified bounds.
Details | Examples | Details and examples
Parameters
Number

Specifies the number to compare to the bounds.

Supported types: Numeric.
LowBound

Specifies the lower bound that Number should not exceed for TRUE to be returned. Note that LowBound must be less than HighBound.

Supported types: Numeric.
HighBound

Specifies the higher bound that Number should exceed for TRUE to be returned. Note that HighBound must be greater than LowBound.

Supported types: Numeric.
Returns
Returned types: Boolean.
Examples
1.

The following example returns True.

OUTOFRANGE(-1, 0, 10)
2.

The following example returns False.

OUTOFRANGE(5, 0, 10)