Manuals/calci/XBETWEEN

Revision as of 15:17, 20 March 2017 by Devika (talk | contribs)
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

See Also

References

Between