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 an example of how to use it when rounding numbers in Excel.
Excel ROUND Function
Rounding Numbers in Excel 2007
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.
Excel ROUNDDOWN Function
Rounding Numbers in Excel 2007
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.
Excel ROUNDUP Function
Rounding Numbers in Excel 2007
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. This tutorial includes an example rounding numbers using the ROUNDUP function.
Excel INT Function
Rounding Numbers in Excel 2007
The INT function will only round numbers downwards to the next whole number or integer. The decimal part of a number is removed entirely. This tutorial includes an example of rounding numbers in Excel using the INT function.
Excel TRUNC Function
Rounding Numbers in Excel 2007
The Excel TRUNC function does a job similar to Excel's ROUND 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. This article includes a step by step example of using the TRUNC function.
Excel CEILING Function
Rounding Numbers in Excel 2007
The CEILING function is used to round a number upwards to a specified multiple. This tutorial includes an example of rounding numbers in Excel using the CEILING function.
Excel FLOOR Function
Rounding Numbers in Excel 2007
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. This tutorial includes an example of rounding numbers in Excel using the FLOOR function.
Excel MROUND Function
Rounding Numbers in Excel 2007
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. This tutorial includes an example of rounding numbers in Excel using the MROUND function.
