• Share

Discuss in my forum

# Rounding Numbers in Excel

## A list of Functions for Rounding Numbers in Excel

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.

Ted French