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 |