ROUND (round to n digits)

<< Click to Display Table of Contents >>

ROUND (round to n digits)

Syntax:

ROUND(Number, n)

Description:

This rounds Number to n decimal places.

n is the desired 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 a 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