Difference between revisions of "Manuals/calci/XBETWEEN"
Jump to navigation
Jump to search
(Created page with "XBET") |
|||
(3 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | <div style="font-size:30px">'''XBETWEEN (FirstValue,Value,SecondValue)'''</div><br/> | |
+ | *<math>FirstValue</math> is the minimum value. | ||
+ | *<math>Value</math> is any number. | ||
+ | *<math> SecondValue</math> is the maximum value. | ||
+ | |||
+ | ==Description== | ||
+ | *This function is the tester function of in between values. | ||
+ | *In <math>XBETWEEN (FirstValue,Value,SecondValue)</math>, <math>FirstValue</math> is the minimum value,<math>SecondValue</math> is the maximum value and <math>Value</math> 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== | ||
+ | #XBETWEEN(30,65,100)= true | ||
+ | #XBETWEEN(654,754,700)= false | ||
+ | #XBETWEEN(12.001,12.01,12.10) = true | ||
+ | #XBETWEEN(-45,-30,-20) = true | ||
+ | |||
+ | |||
+ | a=-1; | ||
+ | ⧓(1,a,30) | ||
+ | a=29; | ||
+ | ⧓(1,a,30) //between g | ||
+ | |||
+ | a=31; | ||
+ | ⧒(1,a,30) //xlbetween g | ||
+ | a=30; | ||
+ | ⧒(1,a,30) //xlbetween g | ||
+ | |||
+ | ⧒(1,2,30) // xlb g | ||
+ | ⧒(1,1,30) | ||
+ | |||
+ | a=29; | ||
+ | ⋈(1,-1..31,30); | ||
+ | |||
+ | ⧓(1,-1..5,4); | ||
+ | |||
+ | [ | ||
+ | ⧓(1,1,30), | ||
+ | ⧓(1,0,30), | ||
+ | ⧓(1,10,30), | ||
+ | ⧓(1,31,30), | ||
+ | ⧑(1,29,30), | ||
+ | ⧑(1,30,30), | ||
+ | ⧑(1,1,30), | ||
+ | ⧑(1,30,30), | ||
+ | ⋈(1,1,30), | ||
+ | ⋈(1,3,30) | ||
+ | ] | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|v=ZjdYKbhfiUU|280|center|Count Values}} | ||
+ | |||
+ | ==See Also== | ||
+ | *[[Manuals/calci/BETWEEN | BETWEEN]] | ||
+ | *[[Manuals/calci/MEDIAN | MEDIAN ]] | ||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | *[[ Z3 | Z3 home ]] | ||
+ | |||
+ | ==References== | ||
+ | [https://support.klipfolio.com/hc/en-us/articles/215547608-BETWEEN-function Between] | ||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Latest revision as of 20:23, 10 August 2024
XBETWEEN (FirstValue,Value,SecondValue)
- is the minimum value.
- is any number.
- is the maximum value.
Description
- This function is the tester function of in between values.
- In , is the minimum value, is the maximum value and 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
- XBETWEEN(30,65,100)= true
- XBETWEEN(654,754,700)= false
- XBETWEEN(12.001,12.01,12.10) = true
- XBETWEEN(-45,-30,-20) = true
a=-1;
⧓(1,a,30)
a=29;
⧓(1,a,30) //between g
a=31; ⧒(1,a,30) //xlbetween g a=30; ⧒(1,a,30) //xlbetween g
⧒(1,2,30) // xlb g ⧒(1,1,30)
a=29; ⋈(1,-1..31,30);
⧓(1,-1..5,4);
[ ⧓(1,1,30), ⧓(1,0,30), ⧓(1,10,30), ⧓(1,31,30), ⧑(1,29,30), ⧑(1,30,30), ⧑(1,1,30), ⧑(1,30,30), ⋈(1,1,30), ⋈(1,3,30)
]
Related Videos
See Also
References