INT

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)/pre>
    

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.