Round Function in Excel
In this tutorial, you will learn how to round numbers in excel. By learning how to round in excel, you will be able to shape all your decimal numbers according to your preference.
The ways of how to round numbers in excel vary greatly. It is because there are many excel round formulas that you can use according to the type of result you want. Those variations make it better for you to understand how to use all of them. This is so you can use whichever formula you need based on your data processing needs.
Why do We Need to Learn How to Round Decimals in Excel?
In numeric data processing on a spreadsheet file, one of the operations we often use is digits rounding. This process is needed if we have various forms of decimals and we want to organize them. Or probably we need a certain number of digits behind the dot for our data processing. These needs surely add the importance to understand how to do rounding in this software.
As an example of this rounding need at work, let’s say we are processing various sales numbers of a company. In the process, maybe we do various calculation operations that produce various decimal forms. These forms are better uniformed so the look of the final results can be better. For the uniformity process, we need to do our rounding process. Because there are usually many numbers to process, then it is better to utilize an automatic way to do it.
Because of that, we need to understand various ways of how to round numbers in excel. In this spreadsheet software, there are various round functions you can use. Your understanding of them is important especially if you often deal with decimals in your spreadsheet file.
What is How to Round Numbers in Excel?
How to round numbers in excel is a process of adding or subtracting the amount of decimal digits in this tool. Various rounding formulas can help you in doing that process. But, of course, you need to be able to use the right formula according to your needs. The reason is because each of these formulas functions differently.
How do You Round in Excel?
The following will explain how to round numbers in excel by using various kinds of formulas. A brief explanation of each formula’ function is given below:
 ROUND, a formula to solve how to round numbers in excel normally (04 down and 59 up), based on the number of decimals demanded
 ROUNDUP, a formula to solve how to round numbers in excel up, based on the number of decimals demanded
 ROUNDDOWN, a formula to solve how to round numbers in excel down, based on the number of decimals demanded
 MROUND, a formula to solve how to round numbers in excel normally (04 down and 59 up), based on the multiplication factor demanded
 CEILING, a formula to solve how to round numbers in excel up, based on the multiplication factor demanded
 FLOOR, a formula to solve how to round numbers in excel down, based on the multiplication factor demanded
 INT, a formula to solve how to round numbers in excel down to the nearest whole number
 TRUNC, a formula to solve how to round numbers in excel to cut decimals based on the number of decimals demanded
The following will explain the writing process of each of the formula methods one by one.
Method 1: ROUND

Type equal ( = ) in the cell where you want to put the result in

Type ROUND (can be with large and small letters) and open bracket sign after =

Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

Input the number of decimal digits demanded / cell coordinate where it is

Type close bracket sign
 Press Enter

The process is done!
Method 2: ROUNDUP

Type equal ( = ) in the cell where you want to put the result in

Type ROUNDUP (can be with large and small letters) and open bracket sign after =

Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

Input the number of decimal digits demanded / cell coordinate where it is

Type close bracket sign
 Press Enter

The process is done!
Method 3: ROUNDDOWN

Type equal ( = ) in the cell where you want to put the result in

Type ROUNDDOWN (can be with large and small letters) and open bracket sign after =

Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

Input the number of decimal digits demanded / cell coordinate where it is

Type close bracket sign
 Press Enter

The process is done!
Method 4: MROUND

Type equal ( = ) in the cell where you want to put the result in

Type MROUND (can be with large and small letters) and open bracket sign after =

Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

Input the multiplication factor demanded / cell coordinate where it is

Type close bracket sign
 Press Enter

The process is done!
Method 5: CEILING

Type equal ( = ) in the cell where you want to put the result in

Type CEILING (can be with large and small letters) and open bracket sign after =

Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

Input the multiplication factor demanded / cell coordinate where it is

Type close bracket sign
 Press Enter

The process is done!
Method 6: FLOOR

Type equal ( = ) in the cell where you want to put the result in

Type FLOOR (can be with large and small letters) and open bracket sign after =

Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign. Then type a comma sign ( , )

Input the multiplication factor demanded / cell coordinate where it is

Type close bracket sign
 Press Enter

The process is done!
Method 7: INT

Type equal ( = ) in the cell where you want to put the result in

Type INT (can be with large and small letters) and open bracket sign after =

Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign

Type close bracket sign
 Press Enter

The process is done!
Method 8: TRUNC

Type equal ( = ) in the cell where you want to put the result in

Type TRUNC (can be with large and small letters) and open bracket sign after =

Input the number / cell coordinate where the numeric data which you want to process is after the open bracket sign

Optional:type comma sign ( , ) followed by the number of decimal digits demanded / cell coordinate where it is. If there is no input in this, it will produce a whole number without decimals

Type close bracket sign
 Press Enter

The process is done!
Exercise
After you have learned how to round numbers in excel using various formulas, now let’s do an exercise. It is done so you can deepen your understanding of how to use them.
Download the exercise file from the following link and answer the questions. Please download the answer key file if you have done the exercise and are sure about your answers. Or probably when you are confused about how to answer the questions!
Link to the exercise file:
Download here
Questions
 What is the rounding result if the digit in the spreadsheet is rounded down to 2 decimal digits?
 What is the rounding result if the digit is rounded to 3 multiplication factor?
 What is the result if the digit is changed into a whole number using TRUNC?
Link to the answer key file:
Download here
Additional Notes

For the formulas with the input of the number of decimals demanded (ROUND, ROUNDUP, ROUNDDOWN, and TRUNC) if you input a minus, then the result will be:
 (1) will process your number to the nearest multiplication factor of 10
 (2) will process your number to the nearest multiplication factor of 100
 (3) will process your number to the nearest multiplication factor of 1000
 etc

To increase or decrease your decimals only on the look, you can use the increase decimal/decrease decimal menu. Click the menu in the Home Tab after putting your cursor in the cell where your number is.
Or please rightclick after putting your cursor on that cell. Then choose Format Cells. On the Number Tab, choose Number then change the value in the Decimal Places based on the number of decimals wanted. Then click OK.
However, you must remember that this method only changes the decimal look of your number, not the true value.