OpenOffice3.org Calc 3. Mathematical Functions
INT(Number) Function
Returns the integer number nearest to the
argument “Number”. The argument “Number” can take a positive or negative
numerical value. If the argument is a positive number, it returns the integer
part of that value, removing the decimal part. If the argument is a negative
number, the function returns the integer lower and closer to that number. The
examples can aid to better understand the function.
=INT(3,5) Returns 3. Simply removes the decimal part to the number.
=INT(10) Returns 10. If the argument is an integer, returns the same number.
=INT(-2,2) Returns -3. Returns the integer less than the given number
=INT(-11) Returns -11. The argument is an integer, returns the same number.