Formulas > =ISBETWEEN()
How To Use ISBETWEEN() Function in Google Sheets
Description
How To Actually Use ISBETWEEN() in Sheets
ISBETWEEN(value_to_compare, lower_value, upper_value, lower_value_is_inclusive, upper_value_is_inclusive)
Try ISBETWEEN yourself
In cell D1, use the ISBETWEEN formula to check if the value in cell A1 is between 10 and 20 inclusively. The formula should return TRUE if it is, and FALSE if it isn't.
Hints (2)
-
Remember to specify the lower and upper bounds correctly.
-
Think about whether the bounds should be inclusive or exclusive.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the ISBETWEEN() formula:
Generate a ISBETWEEN() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses ISBETWEEN(). 2 free AI generations, no signup. Members get unlimited use.
Generate a ISBETWEEN() formula