3 Ways to Round Numbers in Excel and Examples

To simplify the results of data operations, rounding of decimal numbers is usually carried out. This rounding can also be done when processing data in Excel. By understanding how to round numbers in Excel, the results will be neater and better.

Apart from that, rounding will also make the subsequent calculation process simpler and less confusing. It's different when the result is still a decimal, then the calculations after that still have a comma.

How to Round Numbers in Excel

A simple explanation, rounding a number is changing the result of a calculation operation so that there are no commas. Meanwhile, another meaning is to reduce the results of mathematical calculations by rounding off the digits.

The rounded number is on the right side of the comma and becomes zero. Indeed, one of the impacts of carrying out this rounding process is that the results are inaccurate and could be smaller. But in special circumstances, rounding is very important.

Because it can simplify the process of using data for the next stage. When the data remains in decimal form, the subsequent calculation process can be quite complicated. An example of rounding is the number 1,234, so you can round it to 1,200 or 1,230.

Depends on rounding to thousands, hundreds or tens. In manual state, without using Excel formulas, rounding has several rules.

  • First, if the number to the right of the comma is 5 to 9, then the rounding result is +1.
  • Second, if the number starts from 0 to 4, then the result is that the number to the left of the comma remains or is not changed.
  • Third, after the rounding process, all numbers to the right of the comma become zero because they are simplified to make the subsequent calculation process easier.

In the Excel application, rounding numbers can be done automatically using a special formula. There are three function formulas for rounding numbers in Excel that can be used, namely ROUND, ROUNDUP and finally ROUNDDOWN. The following is an explanation and how to use it.

Also Read:

1. ROUND function

The first function that can help round data, including the results of mathematical operations in Excel, is ROUND. Using this function will result in rounding the decimal number to the desired number of digits.

ROUND works with the rule that when the number after the comma is equal to 5 or more than 5, then round up. Then if the data is below 5 then round down. The function can be written as “=ROUND(data number or cell; number of digits after comma)”.

An example of how to use it is data containing the number 15.231290. When writing the number of digits after the comma with the number 2, the rounding result is 15.23. If you change it to 4 it will be 15.2312. If the content is 0, then there is no comma or the result is 15.

Then, if you change it again to a negative number or below 0, then the number to the left of the comma is rounded. For example decimal 14351.29084. If you use the number -1, the result is 14350. Then if you change it to the number -3, the result is 14000.

You can also just write the name of the cell in a form like this “=ROUND(cellname;numberofdigitsaftercomma)”. For example “=ROUND(A4;2)”.

2. ROUNDUP function

How to round numbers in Excel can also be done using a function called ROUNDUP. So the purpose of using this function is to be able to round data in the form of decimal numbers upwards to a certain digit.

When the function is executed, the number on the right side of the comma will be rounded to greater than 0. The way to write the formula is not much different, namely in the form “=ROUNDUP(data number; number of digits after comma)”.

How to use it is the same as the ROUND function by using the function formula above. For example, the data content is 19.7384. When put into a function it becomes “=ROUNDUP(19.7384;2)”, the result is 19.74.

If the number of digits after the comma is changed to 1, the result is 19.8 and if it is 0, the result is 20. Then if the number is changed to negative, rounding is done on the number to the left of the comma.

3. ROUNDDOWN function

The opposite of the ROUNDUP function is ROUNDDOWN which has the aim of rounding decimal numbers down or smaller. So rounding will try to change the number closer to 0.

Write the function as “=ROUNDDOWN(data number; number of digits after comma)”. So whatever the number is, it will be zero. For example, 1567.22 uses -2, then the result is 1500. If you replace -3, the result is 1000.

How to round numbers in Excel can be done very easily. Just adjust the rounding model you want. You can choose normal rounding, rounding to a larger number or to a smaller number.

Leave a Reply

Your email address will not be published. Required fields are marked *