# How to Round Off Decimal Values in Excel (2020)

Microsoft Excel is not merely a spreadsheet software; it also provides users with the tools to perform various complex mathematical operations.

One of the mathematical tasks which can be performed is that one can round off decimal values in MS Excel, not only that, you can round off decimal values in whichever way you want, through the various options which are provided by the software.

You can streamline your numerical data using the ROUND functions. Within it, there are ROUND, ROUNDUP, and ROUNDDOWN sub-functions. ## ROUND Function

When you want to round off a number to a specific decimal place, you use the ROUND function. It will round down the number if the digit in the next decimal to the right is between 0 and 4.

Same way, it will round up if the digit in the next decimal to the right is between 5 and 9. In short, it will round up to the decimal place that you configure. For example, if you want to round up 9.53 to one decimal place, it will be 9.5.

Similarly, if you round up 4.567 to two decimal places, you will get 4.57. It can round the number either to the right or left to the decimal point.

To access the ROUND function on Excel, follow the following steps.

1. 1
Go to the ‘Formulas’ menu on the ribbon on the top
2. 2
After selecting, ‘Formulas’, click the ‘Math and Trig’ option in the drop-down menu
3. 3
Click the ‘ROUND’ function on the ‘Math and Trig’ drop-down menu
4. 4
This will open the ‘Functions Arguments’ window, which contains the fields which you will use for computing with the ROUND function.

Then type the number that you want to round off on the “Number” field. You can type the number straight upon the number field, but usually, the number is taken from an existing cell.

For example, if you want to round off a number in the C5 cell, you type C5 on the ‘Number’ field.

Then you have the "Num_Digits" field to specify the number of decimal places the number has to be rounded up to. For example, if you want to round off 2.555 to one decimal, you will type 1 in the “Num_Digits” column. You will get the value 2.6.

In the ‘Num_Digits’ field all the three types of integers can be entered. All of them have different functions as explained below:

• Positive Integers: Entering positive integers in the ‘Num_Digits’ field rounds off the number up to the decimal value specified by the ‘Num_digit’ integer right to its decimal point. It can be 1, 2, 3, 4, 5 and more. For example, entering 4 will round up the number to four places right to the decimal point. 6.54847 will fetch you 6.5485
• Zero: For rounding up the number to the nearest integer. For example, rounding off the number 324.4 will yield the result 324.
• Negative Integers: It will round off the number left to its decimal point, to the nearest integer which is a multiple of 10*n, where n is the integer specified. For example, rounding off, 634 by -1 will get you 630 and -2 will get you 600

Along with this, you can also use the function bar to perform this function if you like. For this you have to:

1. 1
Click on the function bar to activate it.
2. 2
Then type in the formula using this method: =ROUND(number, num_digits), where the ‘number’ is the number being computed and the ‘num_digits’ is the digit to which the computed number will be rounded off to.

For example, if you want to round off a number on the F7 cell to 3 places after the decimal point, you type, ROUND(F7,3) on the function bar. You will get the value.

Same way, you can compute other values also, such as:

• Round off to 2 decimal places, ROUND(D5,2) - Ex. 4.657 will round off to 4.66
• Round off to 1 decimal place, ROUND(G1,1) - Ex. 6.13 will round off to 6.1
• Round off to the nearest integer, ROUND(C3,0) - Ex. 5.4 will round off to 5
• Round off to the 10s place, ROUND(B3,-1) - Ex. 64 will round off to 60
• Round off to the 100s place, ROUND(E4,-2) - Ex. 431 will round off to 400
• Round off to the thousands place, ROUND(B7,-3), and so on.

You can also round off negative numbers using this method. For example, rounding up -33.63 to one decimal place will get you -33.6.

## ROUNDUP Function

Sometimes, you just want to round up the numbers, meaning that you want to increase the value of the number that you want to round off. For this, you need to use the ROUNDUP function. For this,

1. 1
2. 2
After clicking it, select the ‘Math and Trig’ option.
3. 3
After that, click ROUNDUP on the drop-down box

After clicking it, as in the case with the ROUND option, the "Functions Arguments" window will open. You then have to type the number or the cell you want to compute, in the ‘Number’ field and decimal place to which you want to round up to on the ‘Num_digits’ field. For example, you can type 4.45 on the ‘Number’ field and 1 on the ‘Num_digits’ field, and you will get 4.5 as the answer.

You can also use the function bar to round up the numbers. You will need to type in the following syntax,

• ROUNDUP(number, num_digits) where ‘number’ is the cell that you want to compute, and the ‘num_digits’ is the number of decimal places you want to round the number to.

You can:

• Round up a number to three decimal places, ROUNDUP(D7,3)Ex, 65.3784 will round up to 65.379
• Round up a number to two decimal places, ROUNDUP(G2,2)Ex, 77.883 will round up to 77.89
• Round up a number to one decimal place, ROUNDUP(F3,1)Ex, 99.54 will round up to 99.6
• Round up a number to the nearest integer, ROUNDUP(B9,0)Ex, 88.5 will round up to 89
• Round up a number to the 10s place, ROUNDUP(C5,-1)Ex, 88 will round up to 90
• Round up a number to the 100s place, ROUNDUP(E4,-2)Ex, 548 will round up to 600

You can also perform this operation on negative numbers.

## ROUNDDOWN Function

When you want to round down a number, i.e. decrease the value of the number while rounding off, you use the ROUNDDOWN option.

To perform this function, follow the same steps as used for the ROUNDUP function and click the ROUNDDOWN option on the drop-down box.

You will get the “Functions Arguments”  window where you will need to type the number in the ‘Number’ field and the number of decimal places to be rounded down to in the ‘Num_digits’ field. For example, 4.546 rounded down to the 2 decimal places will be 4.54.

You can also perform this function using the Function Bar on the top. You need to use the following syntax:

• ROUNDDOWN(number, num_digits), where the number is the cell that you want to compute, and the num_digits is the decimal place up to which you want to round off.

For example, If you want to round down a number on the B7 to one decimal point, you have to do the following, ROUNDDOWN(B7,1).  You will get the answer. The other examples are as follows:

• If you want to round down the numbers to three decimal points. Ex, 5.6833 will be rounded down to 5.683
• If you want to round down the number to two decimal points. Ex, 7.787 will be rounded down to 7.78
• If you want to round down the number to one decimal point. Ex, 111.66 will be rounded down to 111.6
• If you want to round down the number to the nearest integer.Ex, 34.8 will be rounded down to 34
• If you want to round down the number to 10s place. Ex, 345 will be rounded down to 340
• If you want to round down the number to 100s place.Ex, 748 will be rounded down to 700

### OTHER OPERATIONS

The other operations that can be performed using more functionalities are as follows:

1. 1
MROUND FUNCTION: It will round off a number to the nearest specified multiple. E.g., if the number is 10, and the specified multiple is 3, then the answer will be 9. The syntax for this function is MROUND (number, multiple).
2. 2
CEILING FUNCTION: It will round up a number to the nearest specified multiple. E.g., if the number is 10, and the specified number is 3, then the answer will be 12. The Syntax for this function is CEILING (number, multiple). It works like the MROUND function, but it will always round up.
3. 3
FLOOR FUNCTION: It will round down a number to the nearest specified multiple. E.g., if the number is 20, and the multiple is 3, then the resultant number will be 18. The Syntax for this function is FLOOR (number, multiple). It works like the MROUND function, but it will always round down

### How to Round Down in Excel

These are some of the functions which you can use for rounding off a number. Along with these, various other functions and formulas are also available to aid you in any computation you perform in MS Excel. You just need to know which one to use and how to use it. The Sky's the limit as far as MS Excel is concerned.