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.