BETWEEN

Determines if given value is between two boundary values

BETWEEN( value, boundary 1, boundary 2 )

Returns true if value is between two specified values, returns false otherwise.

Works on numeric values, strings, and dates.

Arguments

Argument	Description
value	Value to assess
boundary 1	Boundary value
boundary 2	Boundary value

Output

Outputs true if value is between specified values, outputs false otherwise.

Example