Contents
In this article, we will talk about three functions that allow you to round numbers in Excel. These are the features ROUNDWOOD, KRUGLVVERH и ROUND DOWN.
Keep in mind that when rounding a number, precision is lost. If you want to maintain the accuracy of the values, then you can simply reduce the number of displayed decimal places, while the number contained in the cell will not change – only the display of the number will change.
ROUNDWOOD
- Round the number to two decimal places.
Note: The figures 1 … 4 rounded down, and 5 … 9 to the big side. For example, 114.721…114.724 will be rounded up to 114.72, and 114.725…114.729 to 114.73.
- Round the number to one decimal place.
- Round the number to the nearest integer.
- Round the number to the nearest ten.
- Round the number to the nearest hundred.
KRUGLVVERH
Function KRUGLVVERH (ROUNDUP) Rounds a positive number up and a negative number down (in the direction away from zero along the number axis). This is how, for example, a number is rounded up to one decimal place up.
ROUND DOWN
Function ROUND DOWN (ROUNDDOWN) rounds a positive number down and a negative number up (in the direction of approaching zero along the number axis). This is how, for example, a number is rounded down to the nearest integer.
