Nearest Integer (INT)
Syntax: INT(Number)
The INT function rounds the given number down to the nearest integer. For example:
=INT(12.3)
returns 12.
Figure 6-4. Sample result of the INT function
See also the sections on the CEILING, EVEN, FLOOR, ODD, ROUND, ROUNDDOWN, and ROUNDUP functions.
Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.