Returns the integer part of a number, truncated towards zero.
Syntax:
INT(number)
Note that this function is NOT compatible with Microsoft Excel for negative numbers. If you require behaviour compatible with Microsoft Excel, use ODF.INT().
Example:
INT(-27.15)
returns the number -27
.
Revisions:
Starting with 2.00, this function will return a serial number when passed a date parameter. The conversion is performed such that all dates starting from 01-Mar-1900 yield the same serial number as Microsoft Excel. Dates earlier than 01-Mar-1900 do not match as Microsoft Excel incorrectly believes 1900 to be a leap year. Fireworkz can also yield (negative) serial numbers for dates before 01-Jan-1900, unlike Microsoft Excel.