Checks whether a provided number is between two other numbers either inclusively or exclusively.
Parts of a ISBETWEEN function
ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)
| Part | Description |
|---|---|
| value_to_compare | The value to test as being between lower\_value and upper\_value. |
| lower_value | The lower boundary of the range of values that value\_to\_compare can fall within. |
| upper_value | The upper boundary of the range of values that value\_to\_compare can fall within. |
| lower_value_is_inclusive [optional] | Whether the range of values includes the lower\_value. By default this is TRUE |
| upper_value_is_inclusive [optional] | Whether the range of values includes the upper\_value. By default this is TRUE |
Examples
Short description of the example being shown below. Feel free to add more rows and columns to the table below if needed.
| FORMULA | OUTPUT |
|---|---|
| =ISBETWEEN(7.9, 1.2, 12.45) | TRUE |
| =ISBETWEEN(1.2, 1.2, 12.45, TRUE) | TRUE |
| =ISBETWEEN(1.2, 1.2, 12.45, FALSE) | FALSE |
| =ISBETWEEN(12.45, 1.2, 12.45, TRUE, TRUE) | TRUE |
| =ISBETWEEN(12.45, 1.2, 12.45, TRUE, FALSE) | FALSE |
| =ISBETWEEN(7.9, 1.2, 12.45, FALSE, FALSE) | TRUE |