Excel ROUND Function

Summary

The Excel ROUND function returns a number rounded to a given number of digits. The ROUND function can round to the right or left of the decimal point.

Purpose

Round a number to a given number of digits

Return value

A rounded number.

Syntax

=ROUND (number, num_digits)

Arguments

number - The number to round.
num_digits - The number of digits to which number should be rounded.

Usage notes

Round works by rounding numbers 1-4 down, and rounding numbers 5-9 up.
The ROUND function rounds numbers to a specified level of precision. It can round to the right or left of the decimal point.
If num_digits > 0, number is rounded to the specified number of decimal places to the right of the decimal point.
If num_digits <>number is rounded to the left of the decimal point (i.e. to the nearest 10, 100, 1000, etc.).
If num_digits = 0, number is rounded to the nearest integer.