Skip to main content

BETWEEN

The BETWEEN function checks if a value falls within a specified range (inclusive).

Syntax​

=BETWEEN(value, start, end)

Parameters​

  • value: The value to check
  • start: The lower bound of the range
  • end: The upper bound of the range

Examples​

=BETWEEN(5, 1, 10) // Returns TRUE
=BETWEEN(0, -5, 5) // Returns TRUE
=BETWEEN(15, 1, 10) // Returns FALSE