Description

 

Return %FALSE if the numeric expression to check is outside the specified limits. If numeric expression to check is inside the specified limits, a number between 1 and 100 is returned depending if numeric expression is closer to lower or upper bound.

 

Syntax

 

n = Between(ExpressionToCheck, LowerValue, UpperValue)

 

Returns

 

Number

 

Parameters

 

 

Remarks

 

If ExpressionToCheck is outside limits, 0 (zero) is returned.

 

If ExpressionToCheck is inside limits, a number between 1 and 100 will be returned.

1 means ExpressionToCheck is = to LowerValue

50 means ExpressionToCheck is exactly in the middle between LowerValue and UpperValue

100 means ExpressionToCheck is = to UpperValue

All other intermediate values will give the idea where ExpressionToCheck is placed.

 

Restrictions

 

See also

 

Inside, Outside, MinMax

 

Examples