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).

Examples:

ROUND(12345.678, 2)

returns the number 12345.68, and

ROUND(12345.678, -2)

returns the number 12300.

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

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