Manuals/calci/ENFORCEINTEGER

ENFORCEINTEGER(Number)


  • is any real number.

Description

  • This function converts or enforces the given number or set of numbers to an integer value.
  • Integer is the number without any decimal or fractional part but it can be the natural number with positive or negative sign.
  • If the   is positive, it is retained as positive only.
  • If the   is negative, it is retained as negative only.
  • Number 'zero' is natural number, neither positive nor negative.
  • The argument can also be a result of any function.

Examples

  1. ENFORCEINTEGER(44) = 44
  2. ENFORCEINTEGER(-2.45) = -2
  3. ENFORCEINTEGER(4/7) = 0
  4. ENFORCEINTEGER(-20/6) = -3
  5. ENFORCEINTEGER(SUM([-5,-30])) = -35

For a set of numbers, the function displays a table as follows -

  • ENFORCEINTEGER(-5.5..5.5)=
Nature Number ENFORCETYPE
integer -5.5 -5
integer -4.5 -4
integer -3.5 -3
integer -2.5 -2
integer -1.5 -1
integer -0.5 0
integer 0.5 0
integer 1.5 1
integer 2.5 2
integer 3.5 3
integer 4.5 4
integer 5.5 5

Related Videos

INT Function

See Also


References