Rounding Number Functions
Included here are the functions in Excel that can be used to round numbers up or down.
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.
The ROUND function is used to reduce a number to a specific number of decimal places. This tutorial includes an example of how to round numbers using the ROUND function.
The ROUNDDOWN function is used to round a number downwards towards the next lowest number. This tutorial includes an example of how to round numbers using the ROUNDDOWN function.
The ROUNDUP function is used to round a number upwards towards the next highest number. This tutorial includes an example of how to round numbers using the ROUNDUP function.
The INT function can be used to round numbers downwards to the next whole number. It is used when you want to quickly remove the decimal part of a number. This tutorial includes an example of how to round numbers using the INT function.
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.
The CEILING function is used to round a number upwards to a specified multiple. This tutorial includes an example of how to round numbers using the CEILING function.
The FLOOR function is used to round a number downwards to a specified multiple. This tutorial includes an example of how to round numbers using the FLOOR function in Excel.
The MROUND function can be used to round a number upwards or downwards to a specified multiple. This tutorial includes an example of how to round numbers using the MROUND function.