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

Last updated