The ISBETWEEN function in Google Sheets provides a straightforward way to determine whether a specified number lies between two defined limits. This function can be particularly useful for data analysis, conditional formatting, and various calculations, allowing users to manage datasets efficiently by evaluating numerical ranges.

Syntax

ISBETWEEN(value, lower_bound, upper_bound)

• value: The number that you want to check if it falls within the specified range.
• lower_bound: The lower limit of the range.
• upper_bound: The upper limit of the range.

Example #1

ISBETWEEN(10, 5, 15)

This function checks if the number 10 is between 5 and 15. Since it is, the result will be TRUE.

Example #2

ISBETWEEN(4, 5, 10)

This function verifies if 4 falls between 5 and 10. As it does not, the result will be FALSE.

Example #3

ISBETWEEN(7, 7, 14)

This function evaluates whether 7 lies between 7 and 14 inclusively. The result will be TRUE since the bounds are included.

Error handling

• VALUE!: This error appears if the parameters provided are not numbers, indicating that the function cannot perform the calculation.
• N/A: This error occurs when an argument is not provided, signaling that necessary inputs are missing for the function to execute.
• NAME?: This error indicates that Google Sheets does not recognize the function name, possibly due to a typo or the incorrect syntax.

Conclusion

In summary, the ISBETWEEN function is a versatile tool within Google Sheets, enabling users to assess whether a specific number resides within a specified range. By employing this function, data analysis becomes more efficient, allowing for clear insights and improved decision-making based on numerical conditions.