In Excel spreadsheets, rounding is essential to compacting calculator and spreadsheet data. When rounding, the next calculation will be simpler and easier. In Excel, to round numbers we can use different Excel functions.
Each rounding function will round the numbers in different ways, so that users can choose to serve the data processing needs in Excel tables. The following article will summarize the rounding functions on Excel.
Functions that round numbers in Excel
1. Round the number with ROUND function
The ROUND function has the formula = ROUND (number, num_digits) .
In that number is the number to be rounded, num_digits is the number of digits to be rounded.
Read how to implement ROUND function in Excel according to the article How to use Round function in Excel.
2. Round the numbers with the ROUNDUP function
The function has the formula = ROUNDUP (number, num_digits) .
This function will round the number larger than the original number and how much larger the value will depend on how the function is used. Where num_digits is a positive value, it will round behind the decimal and the negative value will round to tens, hundreds, .
3. Round the number with the ROUNDDOWN function
The function has the formula = ROUNDDOWN (number, num_digits) .
The ROUNDDOWN function will be contrary to the ROUNDUP function, the result will be a value less than the original value of the number.
4. Round the numbers with the MROUND function
The function has the formula = MROUND (number, multiple) .
The function will round to a multiple of another number. In which multiple is the number to round to its multiple. Number is the value you want to round.
When number and multiple are different, the function will report a #NUM error. If number and multiple are the same, then the result is that number.
The result of the MROUND function rounds up when the number divides multiple is greater than or equal to 1/2 multiple, and vice versa rounds down when the baby is more than 1/2 multiple.
5. Round the numbers using the CEILING function and the FLOOR function
Functions have the following syntax:
In which Significance is the number that needs to round to its multiples, the number and Significance of the function will indicate the #NUM, number is the multiple of Significance, the result will be the same number.
In general, these two functions will have a similar implementation to the MROUND function, which will round to the nearest multiple of some number. But the CEILING function will round the number away from zero, while the FLOOR function rounds back to zero.
6. Function EVEN, ODD function rounds
These two functions will round to the most even and odd integers. Both functions are rounded away from zero.
Formula 2 functions are = EVEN (number) / = ODD (number) .
7. Rounding function of INT, TRUNC
This function will round a number to an integer. We have the INT function syntax = INT (number) .
We have the syntax of TRUNC function = TRUNC (number [, num_digits]) .
Where num_digits is an integer, show how you want to cut the number.
When num_digits is different from 0, the ROUND function is rounded, while TRUNC only removes numbers without rounding.
Note , for positive numbers, the INT function and TRUNC function give the same result. Then num_digits of TRUNC = 0 or none. But as a negative number, the two functions will give different results.
The above are ways to round numbers in Excel, with different rounding cases. Depending on the purpose and content, it is necessary to round up the number of types in the data table, but you can choose the rounding function accordingly.
See more:
I wish you all success!
ncG1vNJzZmismaXArq3KnmWcp51kxKLF0marqGWipMKvsIynrKaalafAbrXNZpyxm5Wh