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.
ROUND syntax & arguments
Syntax
=ROUND(number, num_digits)
-
1
number
RequiredThe number, cell reference, or formula result to round.
-
2
num_digits
RequiredThe number of digits to keep. Positive values round to decimal places, zero rounds to a whole number, and negative values round to the left of the decimal.
Example
=ROUND(B2, 2)
Round the value in B2 to two decimal places.
ROUND caveats
ROUND changes the actual numeric value, so choose the digit count based on how the rounded result will be reused.
-
Positive digits keep decimals
A
num_digitsvalue of2rounds to two decimal places. -
Zero digits round to whole numbers
A
num_digitsvalue of0rounds to the nearest integer. -
Negative digits round left of the decimal
A
num_digitsvalue of-2rounds 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").
Intro ROUND practice problem
Solve the intro problem directly here, or open it on its own page.
Advanced ROUND practice problems
Use ROUND alongside other Excel functions in realistic, less-prescriptive challenges.
