Want to learn more about how to use the Excel ROUND function? This post will give you an overview of how to use the ROUND Function in Excel.
The general formula
=ROUND (number, num_digits)
- number – This is the original number you want to round.
- num_digits – it shows the number of digits you are rounding to.
How to use the round function
- The function rounds the digit of the given number down when the digit is between 1 and 4 and rounds it up when it is between 5 and 9.
- The ROUND function returns value after rounding to the exact number of digits given. It either rounds to the right-hand side or left-hand side of the decimal point.
- In an instance where num_digits is greater than zero, the value is approximated to the given number of decimal places which is done to the right-hand side of the decimal point.
- In an instance where num_digits is less than zero, the value is approximated to the left-hand side of the decimal point (that is, to the nearest tens, hundreds or thousands depending on the number of digits specified).
- When num_digits is equal to zero, the number is approximated to the nearest whole number (integer).
Figure 1. Example of using ROUND function.