<< Click to Display Table of Contents >> ROUND (round to n digits) |
Syntax:
ROUND(Number, n)
Description:
Rounds Number to n decimal places.
n is the number of decimal places.
If n is omitted, Number is rounded to the nearest integer.
If n is a negative value, Number is rounded to the left of the decimal point. For example, if n is -2, Number is rounded to the nearest multiple of hundred (see last example).
Example:
ROUND(1.234, 2) returns 1.23
ROUND(1.235, 2) returns 1.24
ROUND(444.222, 0) returns 444
ROUND(444.222, -2) returns 400
See also:
ROUNDDOWN, ROUNDUP, MROUND, TRUNC, FIXED, INT, EVEN, ODD, CEILING, FLOOR