Formulas > =ISBETWEEN()

How To Use ISBETWEEN() Function in Google Sheets


Checks whether a provided number is between two other numbers either inclusively or exclusively.

Common questions about the ISBETWEEN formula include:
- What is the ISBETWEEN formula?
- How do you use the ISBETWEEN formula in Google Sheets?
- What are the parameters for the ISBETWEEN formula?
- How is the ISBETWEEN formula different from other comparison formulas?

The ISBETWEEN formula can be used to determine if a value is between two given values (inclusive). The formula takes three parameters: (1) the value you are comparing; (2) the lower bound; and (3) the upper bound. The formula returns TRUE if the value is between the lower and upper bounds (inclusive).

The ISBETWEEN formula is commonly mistyped as ISGREATER or ISLESS. Other common misspellings are ISSBETWEEN, ISBETWEN, ISBETWENE, IBETWEEN.

The ISBETWEEN formula is commonly used inappropriately when trying to compare more than two values. The ISBETWEEN formula is designed for two values only and should not be used if more than two values need to be compared.

Common pitfalls when using the ISBETWEEN formula include making sure the order of the parameters is correct (the first parameter should be the value you are comparing, followed by the lower bound, and then the upper bound). If the order of the parameters is incorrect, then the formula won't work properly.

Common mistakes when using the ISBETWEEN formula include mistyping the name of the formula, using the wrong parameters, or not giving enough parameters.

Common misconceptions people may have about the ISBETWEEN formula is that it can compare more than two values or that it can exclude the lower or upper bound from the comparison. The ISBETWEEN formula is designed for two values only and will include the lower and upper bounds when comparing. "

How To Actually Use ISBETWEEN() in Sheets

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

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

Learn more about the ISBETWEEN() formula:

Generate a ISBETWEEN() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.