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

Name |
Type |
Optional |
Meaning |

ExpressionToCheck |
Numeric |
No |
Numeric expression to check |

LowerValue |
Numeric |
No |
Lower limit value (included) |

UpperValue |
Numeric |
No |
Upper limit value (included) |

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

Examples