< Go Back

Round a number

★ 35 minute read

In Excel, one can round a number in the normal way by specifying the number of values he/she desires. This is available by the use of the ROUND function.

Round a number

Formula

=ROUND(number, digits)

Explanation

The ROUND function in Excel can be used to either round up or down numbers, depending on what you specify. This function is vital, as it can change how the rounded number is stored in a given cell.
Explanation
In the syntax, the number argument shows the value to be rounded, while digits show the number of digits to which you want the number to be rounded. Note that putting a zero (0) as the digits in the argument, the function will round the number to the nearest integer.

It is also important to note that if you specify the digits argument as a positive number, then the formula will round the number to the specified decimal places. If it is a negative number, then Excel will round it off to the left of the decimal point.

The Excel ROUND function works by rounding numbers between 1 and 4 down, and those between 5 and 9 up. It rounds numbers to a given precision, which is provided by the operator.

Example 1

 

Example 1: How to round a number in Excel

In the above example, we want to round all the numbers in column A to the specific numbers of digits in column B. Our results will be in column C.
To do this, we shall specify our ROUND formula in cell C2 as shown below:

=ROUND(A2,B2)

 

 

Example 1: How to round a number in Excel

After you have specified your argument, press “Enter” for you to get the answer.
After getting the answer for the first cell, you can hold and drag the formula across all other cells downwards. The final result shall be as below:

 

Example 1: How to round a number in Excel

In our example above, we have specified the digits as positive numbers. This is why we have all the results as rounded to the right of the decimal point. If, on the other hand, we had specified them as negative numbers, then we could be having the numbers rounded to the left of the decimal point.

Example 2

Let us briefly look at an example where our specified digits assume a negative value.

 

 

Example 2: Round a number with negative digits specified

Notice cell C5, where we have the result as zero (0). This is because the number we want to round does not have the specified digits to its left.

There are many instances when the Excel ROUND function can be used. Majorly, this function is useful in the banking sector, where money needs rounding off to the nearest dollars. It would be so difficult if the accountant was to work with figures that are varying in the number of digits, just because of the decimal points.
This function can also be utilized in the corporate world. When it comes to matters money, high precision is the important part for accountants, and without the Excel ROUND numbers function, then this can be a very tedious task.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar