How to Round Off Numbers in Excel (4 Easy Ways)

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.

The dataset

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.

Round off Price (2 Decimal)

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)

Round off Total

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.]

Round to the nerest multiple of 10

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.

Round Up Price (1 Decimal)

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.

Round Up Total

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.

Round Down Price (1 Decimal)

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.

Round Down Total

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.

Entering the MROUND function

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.

Entering the INT function

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

Chinmoy Mondol

Greetings! Thank you for visiting my profile. I am Chinmoy Mondol. I am a conscientious, tech enthusiast individual with a voracious appetite for knowledge and a desire to learn more. I graduated from American International University-Bangladesh with a Bachelor's Degree in Computer Science and Engineering. I enjoy using my skills to contribute to the exciting technological advances that happen every day. Constant advancement and personal development are my guiding principles.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo