If you are someone who often has to use Excel on a computer to perform calculations and frequently encounter results with decimal numbers containing many digits after the decimal point, then don’t worry, FPT Shop will reveal to you how to solve this problem.
What is the ROUND function in Excel?
The add and subtract functions in Excel are the most popular. In addition, Excel also has many other functions to help users calculate simple data. Among them, the ROUND function in Excel has the function of quickly and effectively rounding decimal numbers. In cases where the numbers after the decimal point are too long, people often use the rounding function to shorten them. The ROUND function is often used in average calculations, payroll tables, and payment invoices.
Structure of the ROUND function in Excel
In the Microsoft Excel software, the ROUND function has the following structure:
=ROUND(Number, Num_digits)
Explanation:
Number: is the number that you want to round.
Num_digits: is the number of digits to round off.
Some notes when using the ROUND function
- In the case of Num_digits being a positive number: It will round the number to the specified decimal places.
- In the case of Num_digits being a negative number: It will round the number to the left of the decimal point.
- In the case of Num_digits being equal to 0: It will round to the nearest whole number.
- In the case of using the ROUNDUP function: To round up the number.
- In the case of using the ROUNDDOWN function: To round down the number.
- In the case of using the MROUND function: To round to a specific multiple.
Some examples of using the ROUND function in Excel
To make it easier to understand the usefulness of the ROUND function in Excel, you can refer to the examples below:
- When you want to round 5.17 to 1 decimal place.
- When you want to round 5.146 to 1 decimal place.
- When you want to round -4.478 to 2 decimal places.
- When you want to round 21.258 to the left of the decimal point.
- When you want to round 600.8 to the nearest multiple of 1000.
- When you want to round -60.48 to the nearest multiple of 100.
- When you want to round 3.94 to the nearest multiple of 10.
To be able to use the ROUND function quickly and simply, you enter those data into Excel.
Then, based on the formula below to implement:
- To round 5.17 to 1 decimal place, perform =ROUND(5.15,1).
- To round 5.146 to 1 decimal place, perform =ROUND(5.149,
- To round -9.478 to 2 decimal places, perform =ROUND(-9.475,2).
- To round 21.258 to the left of the decimal point, perform =ROUND(21.256,-1).
- To round 600.8 to the nearest multiple of 1000, perform =ROUND(600.5,-3).
- To round -60.48 to the nearest multiple of 100, perform =ROUND(-60.55,-2).
- To round 3.94 to the nearest multiple of 10, perform =ROUND(3.98,-1).
The results obtained after applying the ROUND function to the calculation:
- After applying =ROUND(5.17,1) get the result: 5.2.
- After applying =ROUND(5.146,1) get the result: 5.1.
- After applying =ROUND(-9.478,2) get the result: -9.48.
- After applying =ROUND(21.258,-1) get the result: 20.
- After applying =ROUND(600.8,-3) get the result: 1000.
- After applying =ROUND(-60.48,-2) get the result: -100.
- After applying =ROUND(3.94,-1) get the result: 0.
Other related functions to the ROUND function that you should know
Aside from the ROUND function, there are other related functions in Excel such as ROUNDUP, ROUNDDOWN, and MROUND. Let’s refer to the formulas and how to use them right below:
Roundup function formula
The Roundup function is used to round up the original value and the amount of increase will depend on how you use this function.
Roundup formula: =ROUNDUP(Number,num_digits)
Explanation:
- Number: Is the number that needs to be rounded.
- Num_digits: Is the number of digits, can be positive or negative.
- In the case of num_digits = 0: Then we will round to the nearest whole number.
- If num_digits > 0: Then the number will be rounded to the specified decimal places. If num_digits = 1, we will get one odd number, num_digits = 2 we will get two odd numbers,…
- If num_digits < 0: Then the number will be rounded to the left of the decimal point. If num_digits = -1 we will round to double digit, num_digits = -2 we will round to the hundreds digit, num_digits = -3 we will round to the thousands digit,...
Guide to using the Roundup function
If you want to round the numbers: 6.1, 2.9, and 5.15159. Perform the formula as shown below:
Rounddown function formula
The Rounddown function will give the result, rounded down the original value and the amount of decrease will depend on how you use the function.
Rounddown formula: =ROUNDDOWN(Number, num_digits)
Explanation:
- Number: Is the number that needs to be rounded.
- Num_digits: Is the parameter, can be positive or negative depending on the case.
- In the case of num_digits = 0: Then we will round to the nearest whole number.
- If num_digits > 0: Then the number will be rounded to the specified decimal places. If num_digits = 1 we will get one odd number, num_digits = 2 we will get two odd numbers,…
- If num_digits < 0: Then the number will be rounded to the left of the decimal point. If num_digits = -1 we will round to double digit, num_digits = -2 we will round to the hundreds digit, num_digits = -3 round to the thousands digit,...
If you want to round down the numbers 6.1, 2.9, and 5.15159. Perform the formula as shown below:
MROUND formula
The MROUND function is used to round numbers to multiples of other numbers.
MROUND formula: =MROUND(Number, num_digits)
Explanation:
- Number: Is the number that needs to be rounded.
- Num_digits: is the parameter, this number can be positive or negative depending on the case.
In case the two numbers number and num_digits have different signs, the function will give an error #NUM. If number and num_digits have the same sign, the displayed result is the number itself.
If you want to round the numbers 8, -8, and 3.7 respectively to multiples of 3, -3, and 0.2, perform the formula as shown below:
Conclusion
Through this article, FPT Shop hopes that you have a clear understanding of the ROUND function in Excel. The function has the function of rounding numbers to a certain precise number of digits, making the spreadsheet more tidy, scientific, and especially helping you process data faster. If you have any further questions, please leave a comment below!