How to Use ISBETWEEN in Google Sheets (2024 Guide)

How to Use ISBETWEEN in Google Sheets

The ISBETWEEN function in Google Sheets is used to check if a value falls within a specified range, including the boundary values. It returns TRUE if the value is within the range and FALSE otherwise.

ISBETWEEN Syntax

The syntax is: 

ISBETWEEN(value_to_compare, lower_value, upper_value, [lower_value_is_inclusive], [upper_value_is_inclusive])

value_to_compare: The value to check.

lower_value: The lower bound of the range.

upper_value: The upper bound of the range.

[lower_value_is_inclusive]: Indicates whether the comparison should include the lower bound. By default, this is set to TRUE.

[upper_value_is_inclusive]: Indicates whether the comparison should include the upper bound. By default, this is set to TRUE.

Example

Below are some examples on how you can apply ISBETWEEN in Google Sheets:

Check if a number is between 10 and 20 (inclusive)

=ISBETWEEN(15, 10, 20)

This will return TRUE because 15 is between 10 and 20.

Check if a number is between 10 and 20 (exclusive)

=ISBETWEEN(10, 10, 20, FALSE)

This will return FALSE because 10 is the lower boundary and is not included in the range.

Check if a date is within a specific range

Suppose you want to check if the date in cell A1 is between January 1, 2021 and December 31, 2021 (inclusive):

=ISBETWEEN(A1, DATE(2021, 1, 1), DATE(2021, 12, 31))

This will return TRUE if the date in A1 is within 2021.

Using text values (Alphabetical comparison)

=ISBETWEEN("E", "A", "G")

This will return TRUE because "E" falls between "A" and "G" alphabetically.

We hope that this article has helped you and given you a better understanding of how to use ISBETWEEN in Google Sheets. If you enjoyed this article, you might also like our articles on how to find the highest value in Google Sheets and how to set up conditional formatting for dates within 30 days in Google Sheets.