Difference between revisions of "Manuals/calci/XLRBETWEEN"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''XLRBETWEEN (FirstValue,Value,SecondValue)'''</div><br/> *<math>FirstValue</math>,<math>Value</math> and <math>SecondValue</math> are any number....") |
|||
| Line 9: | Line 9: | ||
==Examples== | ==Examples== | ||
| − | + | # XLRBETWEEN(30,54,100) = true | |
| + | # XLRBETWEEN(3,5.2,10) = true | ||
| + | # XLRBETWEEN((-10),75/3,20) = false | ||
| + | # XLRBETWEEN(2/3,15/2,165/7) = true | ||
==See Also== | ==See Also== | ||
Revision as of 13:06, 13 April 2018
XLRBETWEEN (FirstValue,Value,SecondValue)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FirstValue} ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Value} and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SecondValue} are any number.
Description
- This function is the tester function of in between values.
- In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle XLRBETWEEN (FirstValue,Value,SecondValue)} ,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle FirstValue} is the minimum value,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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
- XLRBETWEEN(30,54,100) = true
- XLRBETWEEN(3,5.2,10) = true
- XLRBETWEEN((-10),75/3,20) = false
- XLRBETWEEN(2/3,15/2,165/7) = true
See Also
References