ROUND

See also A-Z Spreadsheet Function List

Description Rounds the given number to the supplied number of decimal places.

Syntax ROUND(number, precision)

number is any value.

precision is the number of decimal places to which number is rounded.

When a negative precision is used, the digits to the right of the decimal point are dropped and the absolute number of significant digits specified by precision are replaced with zeros.

If precision is 0, number is rounded to the nearest integer.

See Also CEILING , FLOOR , INT , MOD , and TRUNC functions

Examples ROUND(123.456, 2) returns 123.46

         ROUND(9899.435, -2) returns 9900