Manuals/calci/BETWEENCORE

Revision as of 15:42, 27 November 2018 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
BETWEENCORE (FirstValue,Value,SecondValue,Type)


  • is the minimum value.
  • is the maximum value.
  • is any real number.

Description

  • This function is the tester function of in between values.
  • In  ,   is the minimum value,  is the maximum 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 this function will return the result as FALSE.

Examples

  1. BETWEENCORE(10,32,100) = true
  2. BETWEENCORE(-10,-3,0) = true
  3. BETWEENCORE(1.001,1.2,1.01) = false
  4. BETWEENCORE(1/4,1/2,3/4) = true

Related Videos

Count Values

See Also


References

Between