Round Your Data

Round is a function which allows you to round your data. There are 3 variations in the function.

1. Round - Round Data According to Standard Rules
2. Round Up - Round Up Your Data
3. Round Down - Round Down Your Data

You can download example file from here.

Round

The basic format of this is below.

=round(number,num_digits)

Number means the number you want to round. Num_digits refers to the number of decimal places in the final answer. Lets see how this works.

= round(23.41,0)

= 23

= round(5.56,1)

= 5.6

= round(12.33,2)

= 12.33

Round Up

The basic format of this function

=roundup(number,num_digits)

Meanings of number and num_digits are same as Round function. See how this works

= roundup(23.41,0)

= 24

= roundup(5.56,1)

= 5.6

= roundup(12.33,2)

= 12.33

Round Down

Round Down function is also works as above functions and see the variations.

Further, if you want to round in to tens' place just enter -1 as num_digits. See the equation below.

= round(23.41,-1)

= 20