IsBetween Function

Returns true if a value is equal to or between two boundary values.

Syntax

IsBetween(value, betweenMinimum, betweenMaximum)

Returns true if a value is equal to or between two boundary values.

Arguments

value Expression - The test value.

betweenMinimum Any - The first boundary.

betweenMaximum Any - The second boundary.

Remarks

• The two boundary values may be in any order.

Example:

IsBetween(5, 1, 10); // returns true

Example:

IsBetween(5, 10, 1); // returns true

Example:

IsBetween(5, 6, [null]); // returns true

Example:

IsBetween("Jefferson", "Adams", "Lincoln"); // returns true