Table of Contents
The ISBETWEEN function in Google Sheets allows users to determine if a specified value falls within a given range of values. To use this function, simply enter the value to be checked, followed by the lower and upper bounds of the desired range. The function will return a TRUE or FALSE result, indicating whether the value is within the specified range or not. This can be useful for organizing and analyzing data, as well as performing conditional formatting and data validation in spreadsheets.
ISBETWEEN
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 |
Related functions
- GT
- GTE
- LT
- LTE
Cite this article
stats writer (2024). How can I use the ISBETWEEN function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-isbetween-function-in-google-sheets/
stats writer. "How can I use the ISBETWEEN function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-isbetween-function-in-google-sheets/.
stats writer. "How can I use the ISBETWEEN function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-isbetween-function-in-google-sheets/.
stats writer (2024) 'How can I use the ISBETWEEN function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-isbetween-function-in-google-sheets/.
[1] stats writer, "How can I use the ISBETWEEN function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the ISBETWEEN function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.