When it comes to mathematical operations, one of the most efficient computer programs to use is Microsoft Excel. Lots of businesses, companies, professionals and students depend to this program for them to efficiently organize and compute data on a daily basis, especially professional Excel consultants. One of the vital Excel function in mathematical operation is the Round function. This is usually used when computing values in decimal form.
Round function converts a certain number to be rounded to a definite digit or whole numbers. Basically, round function rounded a certain cell value by following the usual rounding rule which is round the answer down once the decimal number is less than 5 and round the answer up once the decimal number is greater than or equal to 5.
Round Function Formula:
=ROUND(number, number of digits)
Number – is the desired figure to round on.
Number of digits – is the number of digits required to round to.
- Once the number of digit is higher than 0 then the number is rounded to the particular number of desired decimal points.
- Once the number of digit is 0 then the answer is rounded to the closest integer.
- Once the number of digit is lower than 0, the answer is rounded to only one decimal place.
In order to know properly the number of digits, it is vital to understand first the place value and decimal places.
Round Function Examples
For instance, the value in cell D2 is equal to 874592.253685.
=ROUND(D2,2) – in this method, Excel will round the value of D2 to 2 decimal places, which is identified as hundredth. Excel will look to the number after the hundredths place, since 3 is less than 5, Excel will round down the hundredth place and the answer for the function is 874592.25
=ROUND(D2,1) – Excel will round the value of D2 to only one decimal place, which is called as tenth. Excel will look to the number after the tenth place, since it is 5, and according to the rule once the succeeding value is equal to five the number should be round up. Therefore, Excel will round up the tenth place and the answer acquired for this function is 874592.3.
=ROUND(D2,0) – in this function, Excel will round the value of D2 to the closest integer or whole number. Excel will look to the number after the decimal point, since it is less than 5, Excel will round it down and the answer for this function is 874592.
=ROUND(D2,-1) – in this Excel function, it will round the value of D2 to the closest tens place. Excel will look to the number placed on the ones and since it is less than 5, Excel will round it down and the answer obtained from this function is 874590.
=ROUND(D2,-2) – with this one, Excel will round the value of D2 to the closest hundreds place. Excel will look to the number on the tens place and since it is greater than 5, Excel will round it up and the answer obtained is 874600.
Round function is very important in Excel because it specify how the figure should be displayed in the cell. Since worksheet utilized different mathematical equations having an exact number of answers through the Round function, this is a great way to get accurate mathematical answers. Use this along with the other free Excel help articles to learn how to better utilize Microsoft Excel for your work, even if you are not an Excel consultant.