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)

PartDescription
value_to_compareThe value to test as being between lower\_value and upper\_value.
lower_valueThe lower boundary of the range of values that value\_to\_compare can fall within.
upper_valueThe 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.

FORMULAOUTPUT
=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