ROUND function

ROUND rounds a number to a number of decimal places. This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.

Syntax

ROUND(number, count)

Returns number rounded to count decimal places. If count is omitted or zero, the function rounds to the nearest integer. If count is negative, the function rounds to the nearest 10, 100, 1000, and so on.

Example

=ROUND(2.348,2) returns 2.35.

=ROUND(-32.4834,3) returns -32.483. Change the cell format to see all decimals.

=ROUND(2.348,0) returns 2.

=ROUND(2.5) returns 3.

=ROUND(987.65,-2) returns 1000.