ROUND

Returns the specified number, rounded to the specified number of digits.

Syntax

ROUND( Number n, [Integer digits = 0] ) → Number

Parameters

n

Required. The number to round

digits

Optional. The number of digits to round to. If omitted, digits is assumed to be 0.

Remarks

If digits is greater than 0, the number is rounded to the specified number of decimal places. If digits is 0, the number is rounded to the nearest integer. If digits is less than 0, the number is rounded to the left of the decimal point. If digits is not integer, it is automatically truncated.

Example

Formula

=ROUND(2.15,1)
=ROUND(21.5,-1)

See Also

Function Reference
TRUNC Function
INT Function