between(
VALUE
,
MINIMUM
,
MAXIMUM
)

The between( function checks to see if a value is between two other values.


Parameters

This function has three parameters:

value – the value to check. The value may be a number, date or text.

minimum – minimum value that matches. The minimum may be a number, date or text, but it must be the same type as the value parameter.

maximum – minimum value that matches. The maximum may be a number, date or text, but it must be the same type as the value parameter.


Description

This function checks to see if a value is between two other values. The resut will be true if the value is between or equal to the minimum and maximum values. If the value is outside this range the result will be false.

between(3,2,6) ☞ -1 (true)
between(3,8,6) ☞ 0 (false)
between("e","a","g") ☞ -1 (true)
between("m","a","g") ☞ 0 (false)
between(today(),date("monday"),date("friday")) ☞ -1 (true)

The final example above checks to see if today is a weekday or not. If today is Monday thru Friday the formula returns true, for Saturday and Sunday, it returns false.

Note: This function is equivalent to:

thevalue>=themin and thevalue<=themax

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.