Excel ROUND Function

ROUND changes a number to a specified number of digits.

Use it for currency calculations, rates, percentages, scores, and reports where later formulas should use the rounded numeric value.

Choose a number Use a value, cell, or formula

Choose digit count Positive, zero, or negative

Return a rounded number The result remains numeric

ROUND syntax & arguments

Syntax

=ROUND(number, num_digits)

Required Optional

1

number
Required

The number, cell reference, or formula result to round.
2

num_digits
Required

The number of digits to keep. Positive num_digits values keep that many decimal places, and 0 rounds to a whole number. Negative num_digits values round to multiples left of the decimal, so -1 rounds to the nearest multiple of 10, -2 rounds to the nearest multiple of 100, and so on.

Example

=ROUND(B2, 2)

Round the value in B2 to two decimal places.

ROUND caveats

Positive digits keep decimals

A num_digits value of 2 rounds to two decimal places.
Zero digits round to whole numbers

A num_digits value of 0 rounds to the nearest integer.
5s round away from zero

When the next digit is 5 or higher, ROUND moves to the next value away from zero. For example, =ROUND(2.5,0) returns 3, and =ROUND(-2.5,0) returns -3.
Negative digits round left of the decimal

A num_digits value of -2 rounds to the nearest hundred.
Formatting alone is different

Cell formatting and TEXT can change how a number looks, but ROUND changes the actual value used by later formulas.

Rounding before a comparison? Apply ROUND inside IF when small decimal differences should not change the decision, such as =IF(ROUND(A2,2)=ROUND(B2,2),"Match","Review").