Documentation/How Tos/Calc: INT function

From Apache OpenOffice Wiki
< Documentation‎ | How Tos
Revision as of 06:46, 19 December 2007 by Drking (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


INT

Rounds a number down to the nearest integer.


Syntax:

INT(number)

returns number rounded down to the nearest integer.


Negative numbers round down to the integer below: -1.3 rounds to -2.


Example:

INT(5.7)

returns 5

INT(-1.3)

returns -2.


See also:

TRUNC, ROUND, ROUNDDOWN, ROUNDUP

CEILING, FLOOR, EVEN, ODD, MROUND

Mathematical functions

Personal tools