Round()

Working with Formulas > Functions Used in Formulas > Numeric Functions > Round()

ROUND() returns a number that is rounded to the specified precision. If no precision is specified, ROUND() returns a number that is rounded to the nearest integer.

Function Format

ROUND(number [, precision]) 

Return Value

ROUND() returns a numeric value 

Examples

ROUND(10.333) = 10 

ROUND(10.333, 2) = 10.330 

ROUND(10.666) = 11 

ROUND(10.666, 2) = 10.670 

ROUND(-10.333, 2) = -10.330 

ROUND(-10.666, 2) = -10.67