ROUND


Rounds a number to a certain precision.

Syntax:

ROUND(number, places)
returns number rounded to places decimal places. If places is omitted or zero, the function rounds to the nearest integer. If places is negative, the function rounds to the nearest 10, 100, 1000, etc. This function rounds to the nearest number.

Example:

ROUND(2.348, 2)
returns 2.35
ROUND(2.348, 0)
returns 2
ROUND(2.5)
returns 3
ROUND(987.65, -2)
returns 1000






 
Created with Zapof