These docs are for v1.0. Click to read the latest docs for v1.2.

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

ArgumentTypeDescription
valueAnyThe value to test
lowAnyThe value to use for the low side of the inclusive range
highAnyThe 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.