BETWEEN
Checks if a value is between two other values, inclusive. Returns true if the value is between the specified values, and false if it is not between those values.
Syntax
=BETWEEN(value, low, high)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Any | The value to test |
| low | Any | The value to use for the low side of the inclusive range |
| high | Any | The value to use for the high side of the inclusive range |
Examples
=BETWEEN(200, 0, 100) → false
Tests whether the value 200 is between 0 and 100, inclusive.
=BETWEEN(10, 5, 15) → true
Tests whether the value 10 is between 5 and 15, inclusive.
=BETWEEN(5, 5, 15) → true
Tests whether the value 5 is between 5 and 15, inclusive.
=BETWEEN(20, 5, 15) → false
Tests whether the value 20 is between 5 and 15, inclusive.
=BETWEEN(@"Property 1", 5, 15) → true
Tests whether the shape data property @"Property 1" (10, in this example) is between 5 and 15, inclusive.
=BETWEEN("carrot", "apple", "banana") → false
Tests whether the string "carrot" is between "apple" and "banana", inclusive.
=BETWEEN(date(2023, 12, 18), date(2023, 11, 20), date(2023, 12, 1)) → false
Tests whether the date 2023-12-18 is between 2023-11-20 and 2023-12-1, inclusive.
Updated 9 months ago