ROUND

Returns a number rounded to a number of decimal places.

Syntax:

ROUND(number, digits:Number)

Rounds number to digits decimal places.

digits must be an integer, either positive or negative (which rounds to the left of the decimal point).

Unlike displaying a rounded number using the Number format system, the result of any rounding function is stored in its rounded form, and so any calculations using that result will use the rounded number.

Examples:

ROUND(12345.678, 2)

returns the number 12345.68

ROUND(12345.678, -2)

returns the number 12300.

The ROUND function is particularly useful in VAT calculations to ensure that you avoid odd penny errors.