How to Round Numbers Up or Down in Microsoft Excel

Date:2019-10-21 Author:Cordelia

In the actual mathematical operations especiall financial calculations, you may often encounter the problem of rounding numbers. Although Excel allows you to define the decimal places in cells, the number itself is not really rounded. It could lead to some minor errors in financial operations. So is there any really easy way to round the numbers up or down in Excel cells?

In fact, Excel already provides a function: ROUND(number,num_digits).

It’s composed of two factors – number and number_digits, which means it can round the number in cells according to the specific decimal places.

Take this table as an example, the original number in B2 is 1.526456.

1. To round it with 2 digits after the decimal point, you can input “=ROUND(B2,2)” in C2 and press [Enter] key to get the result.

How to Round Numbers Up or Down in Microsoft Excel

How to Round Numbers Up or Down in Microsoft Excel

2. Similarly, you can input “=ROUND(B2,4)” in D2 to round the number in B2 with 4 digits after the decimal point.

3. To round a series of data, you can use fill handle to apply the ROUND function to the cells of entire column.

How to Round Numbers Up or Down in Microsoft Excel

In this way you can round numbers in Excel accurately and quickly. Have a try!

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

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