LESSOREQUALW function

Synopsis
This function returns whether the number is less than the specified pass and warning bounds.
Variations
LESSOREQUALW(Number, PassBound, WarnBound)
Returns whether the number is less than the pass and warning bounds.
Details | Examples | Details and examples
Parameters
Number

Specifies the number to compare to the bounds.

Supported types: Numeric.
PassBound

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

Supported types: Numeric.
WarnBound

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

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

The following example returns 4 (Fail).

LESSOREQUALW(10, -2, 5)
2.

The following example returns 3 (Warning).

LESSOREQUALW(0, -1, 5)
3.

The following example returns 2 (Pass).

LESSOREQUALW(-2, -1, 5)