ROUND

The ROUND function rounds a value to higher or lower number.

ROUND( number, decimalPlaces )

The Round function rounds the number up if the determining digit is 5 or greater; otherwise, it rounds down. This is commonly referred to as arithmetic rounding.

NOTE: Negative numbers effectively round down if the determining digit is greater than 5 and up if it is less than 5; e.g., -8.6 rounds to -9.  

To round a value up or down to an integer, use the Ceiling function or the Floor function.

number                 The number parameter is the value on which to perform the rounding operation. It can be any value or an expression.

decimalPlaces      The decimalPlaces parameter is used to determine how many decimal places to keep. If decimalPlaces is set to 0, the result will be an integer. If decimalPlaces is a negative number, it specifies the power of 10 to which you want to round.

Function                    Return

Round(172.345, 2)        172.35

Round(-172.345,2)        -172.35

Round(172.345, 0)        172

Round(172.234, -1)       170

Round(172.234, -2)       200