Documentation/Calc Functions/ROUNDDOWN

From The Document Foundation Wiki
Jump to navigation Jump to search
This page contains changes which are not marked for translation.
Other languages:
English • ‎dansk



Function name:

ROUNDDOWN

Category:

Mathematical

Summary:

Rounds a number down, toward zero, to a certain precision. So, it rounds positive numbers down and negative numbers up.

Syntax:

ROUNDDOWN(Number [; Count])

Returns:

Returns Number rounded down (towards zero) to Count decimal places.

Arguments:

Number is a real number or a reference to the cell containing that number which is to be rounded down to a certain number of decimal places.

Count is an integer or a reference to the cell containing that integer which is the number of decimal places to which Number is to be rounded down.

  • If Count is omitted or zero, the function rounds to the nearest integer. If Count is negative, the function rounds to the nearest 10, 100, 1000, etc.
  • If Count is a non-integer value then the function uses the floor of the input value, i.e. it is truncated to an integer. For eg. 2.5 is truncated to 2 and -2.5 is truncated to -2.

Additional details:

This function rounds towards zero. See ROUNDUP and ROUND for alternatives.

Examples:

Formula Description Returns
=ROUNDDOWN(2.348;2) rounds down 2.348 to 2 decimal places 2.34
=ROUNDDOWN(-32.4834;3) rounds down -32.4834 to 3 decimal places -32.483
=ROUNDDOWN(2.648;0) gives integer part of 2.348 by rounding down 2
=ROUNDDOWN(-45.67) rounds down -45.67 to integer towards 0 -45
=ROUNDDOWN(987.65;-2) rounds down 987.65 to 2 places before decimal point 900

Related LibreOffice functions:

ROUND

ROUNDUP

TRUNC

INT

ODF standard:

Section 6.17.6, part2

Equivalent Excel functions:

ROUNDDOWN