Manuals/calci/XLBETWEEN

XLBETWEEN (FirstValue,Value,SecondValue)

• $FirstValue$,$Value$ and $SecondValue$ are any number.

Description

• This function is the tester function of in between values.
• In $XLBETWEEN(FirstValue,Value,SecondValue)$,$FirstValue$ is the minimum value,$SecondValue$ is the maximum value and Value is the number to find the value is in the given range or not.
• This function will return the result as TRUE when the given number with in the given range of values.
• Otherwise will return the result as FALSE.

Examples

1. XLBETWEEN(30,54,100) = true
2. XLBETWEEN(34,48,50) = true
3. XLBETWEEN(3,10,4.7) = false
4. XLBETWEEN((-55),2,20) = true

Related Videos

ROWS

See Also

• BETWEEN
• XLRBETWEEN
• XRBETWEEN

References

Between

• List of Main Z Functions

• Z3 home