OUTOFRANGEW function

Synopsis
This function returns whether the specified number is outside the range of the specified pass and warning bounds.
Variations
OUTOFRANGEW(Number, PassLowBound, WarnLowBound, WarnHighBound, PassHighBound)
Returns whether the function is outside the range of the pass or warning bounds.
Details | Examples | Details and examples
Parameters
Number

Specifies the number to compare to the bounds.

Supported types: Numeric.
PassLowBound

Specifies the lower bound that Number should not exceed for a pass value (2) to be returned.

Supported types: Numeric.
WarnLowBound

Specifies the lower bound that Number should not exceed for a warning value (3) to be returned. If the warning bound is exceeded a fail value (4) is returned. Note that WarnLowBound must be larger than PassLowBound.

Supported types: Numeric.
WarnHighBound

Specifies the upper bound that Number should exceed for a warning value (3) to be returned. If the warning bound is not exceeded a fail value (4) is returned. Note that WarnHighBound must be smaller than PassHighBound.

Supported types: Numeric.
PassHighBound

Specifies the upper bound that Number should exceed for a pass value (2) to be returned.

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

The following example returns 2 (Pass).

OUTOFRANGEW(-3, -3, 0, 5, 10)
2.

The following example returns 3 (Warning).

OUTOFRANGEW(-1, -2, 0, 5, 10)
3.

The following example returns 4 (Fail).

OUTOFRANGEW(2, -2, 0, 5, 10)
4.

The following example returns 3 (Warning).

OUTOFRANGEW(6, -2, 0, 5, 10)
5.

The following example returns 2 (Pass).

OUTOFRANGEW(12, -2, 0, 5, 10)