Round a number

To round a number with a specified number of digits, use the ROUND function. For example, we can round the 2.123456 number to 2.12 by using the ROUND function with two digits.




Copy and paste the formula into other cells after changing num_digits.

How the formula work

The formula used in our example is =ROUND(A4,2) where

number (A5) – The number that you want to round.

num_digits (3) – The number of digits to which you want the number argument.

Copyright © 2016 - 2017 | All Rights Reserved