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.

Example

Formula:

Result:

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 - 2018 Explainry.com | All Rights Reserved