Revision as of 14:37, 20 March 2019 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
XRBETWEEN (FirstValue,Value,SecondValue)

  • , 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.


  1. XRBETWEEN(30,54,100) = true
  2. XRBETWEEN(102,780,1000) = true
  3. XRBETWEEN((-90),30,90) =true
  4. XRBETWEEN(10,67.1,67) = false

Related Videos

Between Values

See Also