Difference between revisions of "Manuals/calci/XLBETWEEN"
Jump to navigation Jump to search
|Line 16:||Line 16:|
Latest revision as of 14:34, 20 March 2019
- , and are any number.
- This function is the tester function of in between values.
- In , is the minimum value, 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.
- XLBETWEEN(30,54,100) = true
- XLBETWEEN(34,48,50) = true
- XLBETWEEN(3,10,4.7) = false
- XLBETWEEN((-55),2,20) = true