Checks whether a provided number is between two other numbers either inclusively or exclusively. Learn more
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.