ISBETWEEN

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

Video field
Operator

The ISBETWEEN function in Google Sheets is used to check if a value is between two other values, with the option to include or exclude the boundaries. The function syntax is as follows:

ISBETWEEN(valuetocompare, lowervalue, uppervalue, lowervalueisinclusive, uppervalueisinclusive)

"valuetocompare" is the value that you want to check if it is between the lower and upper values. "lowervalue" is the lower boundary value for the comparison. "uppervalue" is the upper boundary value for the comparison. "lowervalueisinclusive" is a logical value (TRUE or FALSE) that determines if the lower boundary is inclusive (TRUE) or exclusive (FALSE). "uppervalueisinclusive" is a logical value (TRUE or FALSE) that determines if the upper boundary is inclusive (TRUE) or exclusive (FALSE). Here's an example to illustrate how to use the ISBETWEEN function:

Suppose you have a value of 7 in cell A1, and you want to check if it is between 5 and 10 inclusively. In cell B1, you can use the formula:

=ISBETWEEN(A1, 5, 10, TRUE, TRUE)

The ISBETWEEN function will evaluate if the value in cell A1 is between 5 and 10 inclusively. Since 7 falls within that range, the formula will return TRUE in cell B1.

You can adjust the "lowervalueisinclusive" and "uppervalueisinclusive" parameters as needed to include or exclude the boundaries from the comparison.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!