Excel is an excellent tool for performing mathematical calculations. It comes with a number of built-in functions that simplify this process. One of the most common mathematical operations in MS Excel is rounding off numbers. It can be accomplished in a variety of ways by utilizing a few built-in functions. In this article, Iâ€™ve gone over five such functions and discussed how they can be used to round off values.

## Download the Workbook

You can download the workbook that I used in this article from below and practice with it by yourself.

I attempted to present a real-life example in this dataset. There is an **Item **column with five different clothing items and a **Price** column with their respective prices in Dollars with up to 3 decimal points.

## 4 Ways to Round Off Numbers in MS Excel

### 1. Using the ROUND function

The **ROUND** function rounds a number to a given number of digits.

The syntax of the **ROUND **function is as follows:

**=ROUND (number, num_digits)****number:** The number to round.

**num_digits: **The number of digits to which number should be rounded.

You can learn about this function in detail by reading this documentation from Microsoft.

You can use this **ROUND** function to round off numbers in multiple ways by changing its second argument.

Here, I have rounded off the price of the items to two decimal places showing the output in **column D**.

*Function Breakdown;*

*=ROUND(C5, 2)*

*=> ROUND($450.693, 2)*

*=> $450.690*

*[It rounded off the value in cell C5 to two decimal places based on the third decimal place value.]*

Alternatives usages:

*=ROUND(C5,1) // Round to 1 decimal place*

*=ROUND(C5,3) // Round to 3 decimal places*

*=ROUND(C5,4) // Round to 4 decimal places*

You can also use zero or negative numbers in the second argument to round down the values to the left of the decimal point.

**Read More:** How to Round up Decimals in Excel (4 Simple Ways)

*Function Breakdown;*

*=ROUND(C10, 0)*

*=> ROUND($3,337.766, 2)*

*=> $3,338.000*

*[It rounded off the value in cell C10 to the nearest whole number based on the values after the decimal point.]*

*Function Breakdown;*

*=ROUND(C10, -1)*

*=> ROUND($3,338.000, -1)*

*=> $3,340*

*[It rounded off the value in cell C10 to the nearest 10.]*

Alternatives usages:

*=ROUND(C10,-2) // Round to nearest 100*

*=ROUND(C10,-3) // Round to nearest 1000*

*=ROUND(C10,-4) // Round to nearest 10000*

**Read More: **Excel Round to Nearest 100 (6 Quickest Ways)

### 2. Using the ROUNDUP and ROUNDDOWN function

#### ROUNDUP Function:

The **ROUNDUP** function rounds a number up to a given number of digits.

The syntax of the **ROUNDUP **function is as follows:

**=ROUNDUP (number, num_digits)****number: **The number to round up.

**num_digits: **The number of digits to which number should be rounded up.

You can learn about this function in detail by reading this documentation from Microsoft.

You can use this **ROUNDUP** function to round up numbers in multiple ways by changing its second argument.

Here, I have round up the price of the items to one decimal place shown in the output in **column D**.

*Function Breakdown:*

*=ROUNDUP(C5, 1)*

*=> ROUNDUP($450.693, 2)*

*=> $450.700*

*[It rounded up the value in cell C5 to one decimal place based on the second and third decimal place value.]*

Alternatives usages:

*=ROUNDUP(C5,2) // Round up to 2 decimal places*

*=ROUNDUP(C5,3) // Round up to 3 decimal places*

*=ROUNDUP(C5,4) // Round up to 4 decimal places*

You can also use zero or negative numbers in the second argument to round up values to the left of the decimal point.

*Function Breakdown:*

*=ROUNDUP(C10, 0)*

*=> ROUNDUP($3,337.766, 2)*

*=> $3,338.000*

*[It rounded up the value in cell C10 to the nearest whole number based on the values after the decimal point.]*

Alternatives usages:

*=ROUNDUP(C10,-1) // Round up to nearest 10*

*=ROUNDUP(C10,-2) // Round up to nearest 100*

*=ROUNDUP(C10,-3) // Round up to nearest 1000*

*=ROUNDUP(C10,-4) // Round up to nearest 10000*

**Read More:** Using Excel to Round to Nearest 1000 (7 Easy Ways)

#### ROUNDDOWN Function:

The **ROUNDDOWN** function rounds down to the given number of digits

The syntax of the **ROUNDDOWN **function is as follows:

**=ROUNDDOWN (number, num_digits)****number: **The number to round down.

**num_digits: **The number of digits to which number should be rounded down.

You can learn about this function in detail by reading this documentation from Microsoft.

You can use this **ROUNDDOWN** function to round down numbers in multiple ways by changing its second argument.

Here, I have round down the price of the items to one decimal place shown in the output in **column D**.

*Function Breakdown:*

*=ROUND(C5, 1)*

*=> ROUND($450.693, 2)*

*=> $450.600*

*[It rounded down the value in cell C5 to one decimal place based on the second and third decimal place value.]*

Alternatives usages:

*=ROUNDDOWN(C5,2) // Round down to 2 decimal places*

*=ROUNDDOWN(C5,3) // Round down to 3 decimal places*

*=ROUNDDOWN(C5,4) // Round down to 4 decimal places*

You can also use zero or negative numbers in the second argument to round down values to the left of the decimal point.

*Function Breakdown:*

*=ROUNDDOWN(C10, 0)*

*=> ROUND($3,337.766, 2)*

*=> $3,337.000*

*[It rounded down the value in cell C10 to the nearest whole number based on the* *values after the decimal point.]*

Alternative usages:

*=ROUNDDOWN(C10,-1) // Round down to nearest 10*

*=ROUNDDOWN(C10,-2) // Round down to nearest 100*

*=ROUNDDOWN(C10,-3) // Round down to nearest 1000*

*=ROUNDDOWN(C10,-4) // Round down to nearest 10000*

**Read More: **Excel round to nearest 10000 (5 Easiest Ways)

### 3. Using the MROUND function

The **MROUND** function rounds a number to the nearest specified multiple.

The syntax of the **MROUND **function is as follows:

**=MROUND (number, significance)****number: **The number that should be rounded.

**significance: **The multiple to use when rounding.

You can learn about this function in detail by reading this documentation from Microsoft.

Here, I have rounded the **Price** column to the nearest multiple based on the **Multiple **column.

*Function Breakdown:*

*=MROUND(C5,D5)*

*=> ROUND($450.963, 4)*

*=> $452.000*

*[It rounded the value of cell C5 to the nearest multiple of four as the value of cell D5 is four.]*

### 4. Using the INT function

The **INT** function gets the integer part of a decimal by rounding down.

The syntax of the **INT **function is as follows:

**=INT (number)****number: **The number from which you want an integer.

You can learn about this function in detail by reading this documentation from Microsoft.

Here, I have rounded down the **Price** column to the nearest whole number.

*Function Breakdown:*

*=INT(C5)*

*=> INT($450.963)*

*=> $450.000*

*[It rounded the value of cell C5 to the nearest whole number which is the desired output.]*

## Conclusion

I have narrowed down five functions in this article to round off numbers in MS Excel. I hope you find the solution you were looking for. Please leave a comment if you have any suggestions or questions. Thank you.

## Further Readings

- Excel 2 Decimal Places without Rounding (4 Efficient Ways)
- How to Round to Nearest Multiple of 5 in Excel (3 Easy Ways)
- 4 Easy Ways to Add Leading Zeros in Excel
- Add or Keep Leading Zeros in Excel (10 Suitable Ways)
- Excel Custom Number Format Multiple Conditions
- How to Round Numbers in Excel Without Formula (3 smart ways)
- How to Remove Leading Zeros in Excel (7 Easy Ways + VBA)