IsBetween Function

  • Updated

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

Syntax

 

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

 

IsBetween(value, betweenMinimum, betweenMaximum)

 

 

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.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.