Rounding data in Excel is a very common task. As a result, there are number of rounding functions available and each one does a slightly different job. One rounds up, one rounds down, a third removes all decimal places when it rounds, and another does no rounding at all. An interesting group. All are listed here and each one includes a step by step example of how to use it when rounding numbers in Excel.
The ROUND Function
Rounding Numbers in Excel
The ROUND function is used to reduce a given value to a specific number of decimal places. The ROUND function will round the last number up or down depending on the value of the rounding digit.
The ROUNDDOWN Function
Rounding Numbers in Excel
The ROUNDDOWN function will only round a number downwards towards the next lowest number. This tutorial includes an example rounding numbers using the ROUNDDOWN function.
The ROUNDUP Function
Rounding Numbers in Excel
Well if there is a ROUNDDOWN function there has to be a ROUNDUP function in Excel. The ROUNDUP function only rounds a number upwards towards the next highest number.
The INT Function
Rounding Numbers in Excel
The INT function will only round numbers downwards to the next whole number or integer. The decimal part of a number is removed entirely.
The TRUNC Function
Rounding Numbers in Excel
The Excel TRUNC function does a job similar to Excel's INT function but without actually rounding any numbers. What it does is truncate or shorten a number by a set number of decimal places without rounding what remains.
The CEILING Function
Rounding Numbers in Excel
The CEILING function is used to round a number upwards to a specified multiple.
The FLOOR Function
Rounding Numbers in Excel
As with the ROUNDDOWN and ROUNDUP functions, if there is a CEILING function, then there has to be a FLOOR function. It is used to round a number downwards to a specified multiple.
The MROUND Function
Rounding Numbers in Excel
The MROUND function kinda does the job of both CEILING and FLOOR functions. It can be used to round a number upwards or downwards to a specified multiple.
The EVEN Function
Rounding Numbers in Excel
The EVEN function can be used to round all positive and negative decimal numbers as well as odd-numbered integers to the next even integer.
The ODD Function
Rounding Numbers in Excel
The ODD function can be used to round all positive and negative decimal numbers as well as even-numbered integers to the next odd integer.
