Difference between revisions of "Manuals/calci/XBETWEEN"

From ZCubes Wiki
Jump to navigation Jump to search
Line 15: Line 15:
 
#XBETWEEN(12.001,12.01,12.10) = true
 
#XBETWEEN(12.001,12.01,12.10) = true
 
#XBETWEEN(-45,-30,-20) = true
 
#XBETWEEN(-45,-30,-20) = true
 +
 +
 +
//todo:
 +
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==
 
==Related Videos==

Revision as of 19:22, 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

  1. XBETWEEN(30,65,100)= true
  2. XBETWEEN(654,754,700)= false
  3. XBETWEEN(12.001,12.01,12.10) = true
  4. XBETWEEN(-45,-30,-20) = true


//todo: 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

Count Values

See Also

References

Between