Rounding Number Functions

The ROUND function can be used to reduce a value to a specific number of decimal places or remove the decimal portion altogether. The function rounds the last digit up or down depending on the value of the rounding digit.

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 can be used to reduce or remove the decimal portion of a number. The function will always round the last digit down to the next lowest value.

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 can be used to reduce or remove the decimal portion of a number. The function will always round the last digit up to the next highest value.

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 a number down to the next lowest integer while removing the decimal portion of a number.

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 to a significant number of digits. The last digit is always rounded upward no matter the value of the rounding digit This tutorial includes an example of how to round numbers using the CEILING 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.

Similar to the CEILING function, the FLOOR function always rounds the last digit rounded downward no matter the value of the rounding digit This tutorial includes an example of how to round numbers using the FLOOR 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.