NOTBETWEEN
Checks if a value is not between two other values, inclusive. Returns true if the value is not between the specified values, and false if it is between those values.
Syntax
=NOTBETWEEN(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
=NOTBETWEEN(200, 0, 100) → true
Tests whether the value 200 is not between 0 and 100, inclusive.
=NOTBETWEEN(10, 5, 15) → false
Tests whether the value 10 is not between 5 and 15, inclusive.
=NOTBETWEEN(5, 5, 15) → false
Tests whether the value 5 is not between 5 and 15, inclusive.
=NOTBETWEEN(20, 5, 15) → true
Tests whether the value 20 is not between 5 and 15, inclusive.
=NOTBETWEEN(@"Property 1", 5, 15) → false
Tests whether the shape data property @"Property 1" (10, in this example) is not between 5 and 15, inclusive.
=NOTBETWEEN("carrot", "apple", "banana") → true
Tests whether the string "carrot" is not between "apple" and "banana", inclusive.
=NOTBETWEEN(date(2023, 12, 18), date(2023, 11, 20), date(2023, 12, 1)) → true
Tests whether the date 2023-12-18 is not between 2023-11-20 and 2023-12-1, inclusive.
Updated 9 months ago