excel Excel rounding and precision Using the ROUND function


Example

The ROUND function rounds a value. The number of decimal places to round to is specified by a positive value in the num_digits parameter. A negative value for the num_digits will round the integer portion of the value left of the decimal point, e.g. to the nearest 10 (for -1) or to the nearest 1000 (for -3).

Here's a table showing how round may be used.

Starting withROUND(b,2)ROUND(b,1)ROUND(b)ROUND(b,-1)
23.1065137523.1123.12320
19.1681892419.1719.21920
3.927488833.933.940
31.3820840931.3831.43130
38.3423556138.3438.33840
7.6826324957.687.7810
35.3931541635.3935.43540
20.4700444920.4720.52020
20.4977527620.520.52020
2.2888224972.292.320

Additional similar functions are also available to control the direction of rounding:

  • ROUNDUP - Always rounds a number up, away from zero.
  • ROUNDDOWN - Always rounds a number down, towards zero.