ROUNDDOWN function /text/scalc/01/func_rounddown.xhp ROUNDDOWN function numbers;rounding down

ROUNDDOWN function

Rounds down a number while keeping a specified number of decimal digits.

This function is equivalent to the TRUNC function.

ROUNDDOWN(Number [; Count])

Number: The number to be rounded down. Count: Optional parameter that defines the number of decimal places to be kept. The default value is 0 (zero). Use negative values for Count to round the integer part of the original Number. For example, -1 will round down the first integer number before the decimal separator, -2 will round down the two integer numbers before the decimal separator, and so forth.

In %PRODUCTNAME, the Count parameter is optional, whereas in Microsoft Excel this parameter is mandatory. When an ODS file contains a call to ROUNDDOWN without the Count parameter and the file is exported to XLS or XLSX formats, the missing argument will automatically be added with value zero to maintain compatibility.

=ROUNDDOWN(21.89) returns 21. Note that this example uses the default value for Count which is 0. =ROUNDDOWN(103.37,1) returns 103.3. =ROUNDDOWN(0.664,2) returns 0.66. =ROUNDDOWN(214.2,-1) returns 210. Note the negative value for Count, which causes the first integer value before the decimal separator to be rounded towards zero.

ROUNDDOWN wiki page.