ISBETWEEN

When to use it

When should I use ISBETWEEN?

Use ISBETWEEN to check whether a value falls within a range defined by lower and upper bounds, with optional control over whether each bound is inclusive.

Used in

operations

Syntax

ISBETWEEN(value, lower, upper, [lower_inclusive], [upper_inclusive])