SheetFX
≡
<< Go back to all functions

ISBETWEEN

The ISBETWEEN function in Google Sheets is a useful tool for checking whether a provided number falls within a specified range, either inclusively or exclusively. This function can come in handy when working with data that requires a conditional analysis. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

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

Parameters:

  • value_to_compare: The number or value that needs to be compared.
  • lower_value: The lower boundary of the range to compare against.
  • upper_value: The upper boundary of the range to compare against.
  • lower_value_is_inclusive: [Optional] TRUE or FALSE indicating whether the lower boundary should be included in the comparison. Defaults to TRUE.
  • upper_value_is_inclusive: [Optional] TRUE or FALSE indicating whether the upper boundary should be included in the comparison. Defaults to TRUE.

Step-by-Step Tutorial

  1. Using ISBETWEEN inclusively:

    • Example: =ISBETWEEN(5, 1, 10, TRUE, TRUE)
    • Result: TRUE

  2. Using ISBETWEEN exclusively:

    • Example: =ISBETWEEN(5, 1, 10, FALSE, FALSE)
    • Result: FALSE

Use Cases and Scenarios

  1. Data Validation: Ensure entered values fall within specific ranges.
  2. Conditional Formatting: Highlight values that meet certain criteria.
  3. Filtering Data: Create filters based on number ranges.

Related Articles