ROUND(number, num_digits)

Returns the number rounded to a specified number of digits.

numberThe number you want to round.
num_digitsThe number of digits to which you want to round to.

Remarks

* Any digits less than 5 are rounded down.
* Any digits greater than or equal to 5 are rounded up.
* The "number" can be a number, a cell reference or a named range.
* If "num_digits" > 0, then "number" is rounded to the specified number of decimal places.
* If "num_digits" = 0, then "number" is rounded to the nearest integer.
* If "num_digits" < 0, then "number" is rounded to the left of the decimal point.
* This function operates on the actual value in the cell and rounds them so they are consistent with the value that is displayed.
* Using this function will change the underlying value and not just the value that is displayed.
* You can use the ROUNDDOWN function if you always want the number rounded down to the nearest integer.
* You can use the ROUNDUP function if you always want the number rounded up to the nearest integer.
* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.
* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.
* You can use the MROUND function to round to a desired multiple.
* You can use the EVEN function to round up to the nearest even integer.
* You can use the ODD function to round up to the nearest odd integer.
* For the Microsoft documentation refer to support.office.com

 A
1=ROUND(123.456,-4) = 0
2=ROUND(123.456,-3) = 0
3=ROUND(123.456,-2) = 100
4=ROUND(123.456,-1) = 120
5=ROUND(123.456,0) = 123
6=ROUND(123.456,1) = 124
7=ROUND(123.456,2) = 123
8=ROUND(123.456,3) = 123
9=ROUND(123.456,4) = 123
10=ROUND(56.78,-4) = 0
11=ROUND(56.78,-3) = 0
12=ROUND(56.78,-2) = 100
13=ROUND(56.78,-1) = 60
14=ROUND(56.78,0) = 57.00
15=ROUND(56.78,1) = 56.80
16=ROUND(56.78,2) = 56.78
17=ROUND(56.78,3) = 56.78
18=ROUND(56.78,4) = 56.78


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top