Google Sheets Function: ISBETWEEN

The ISBETWEEN function checks if a value is within a defined range and returns TRUE if it is and FALSE otherwise.

This function is commonly used in combination with other functions, especially the IF function.

Usage:

=ISBETWEEN(value_to_compare, lower_value, upper_value)

or

=ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)

Using the Function Alone

The goal here is to check if the individual's age is between 18 and 64.

So, the value to compare is the individual's age, and the other 2 values define the limits of the range:

=ISBETWEEN(B2,18,64)

Usage with Another Function

The ISBETWEEN function can only return TRUE or FALSE, which is why it is most often used with other functions.

To display "Yes" or "No" instead of TRUE and FALSE, nest this function in an IF.

The formula becomes:

=IF(ISBETWEEN(B2,18,64),"Yes","No")

Exclude Range Limits

By default, the range limits are included in the range. To exclude them, add FALSE (or 0) as the fourth argument (for the lower limit of the range) and as the fifth argument (for the upper limit of the range).

For example, to check if a number is between 0 and 1 (excluding 0 and 1), enter:

=ISBETWEEN(A2,0,1,FALSE,FALSE)