Round(column, decimalplaces)

 Top  Previous  Next

Rounds data points in column to decimalplaces number of decimal places.  If decimalplaces is negative, the data points are rounded to the nearest 10, 100, 1000 and so on.

 

Data

54.0513321

93.5850093

79.5159764

78.2189397

52.4185918

49.4979705

57.3778496

11.9083224

Round(A,2)

54.05

93.59

79.52

78.22

52.42

49.5

57.38

11.91

Round(A,0)

54

94

80

78

52

49

57

12

Round(A,-1)

50

90

80

80

50

50

60

10

 

Note:  If you type decimals using a comma (eg 3,2) you should enter this formula as Round(A; 1)  - using the ; as a separator