INRANGE function
Synopsis
This function
returns whether the specified number is in range of the specified
bounds.
Variations
INRANGE(
Number,
LowBound,
HighBound)
Returns whether the function is in
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 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 not exceed for TRUE to be returned. Note that HighBound must be greater than LowBound.
Supported types: Numeric.
Returns
Examples
| 1. |
The following example returns False.
INRANGE(10,12,15)
|