INRANGEW function

Synopsis
This function returns whether the specified number is within the range of the specified pass and warning bounds.
Variations
INRANGEW(Number, WarnLowBound, PassLowBound, PassHighBound, WarnHighBound)
Returns whether the function is within 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.
WarnLowBound

Specifies the lower 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 the lower warning bound must be less than the lower pass bound.

Supported types: Numeric.
PassLowBound

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

Supported types: Numeric.
PassHighBound

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

Supported types: Numeric.
WarnHighBound

Specifies the upper 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 the higher warning bound must be greater than the upper pass bound.

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

The following example returns 3 (Warning).

INRANGEW(10,-2,0,5,10)