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

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

### 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 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

#### 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 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

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

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.

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.  