ROUND in Excel: control decimal places and stored results

What ROUND does

ROUND returns a number rounded to a chosen number of digits. The syntax is `=ROUND(number, num_digits)`. The number is the value you want to round. The num_digits argument tells Excel where to round.

For example, `=ROUND(A2,2)` rounds the value in A2 to two decimal places. If A2 contains 12.346, the result is 12.35. This changes the formula result. It is not the same as simply formatting the cell to show two decimals.

ROUND follows normal rounding rules. Values halfway or above round away from zero at the rounding position, while lower values round toward zero at that position.

Arguments explained

`number` can be a cell reference, a calculation, or a typed number. `num_digits` controls precision. Positive digits round to decimal places. `=ROUND(A2,2)` rounds to cents or two decimals.

Zero digits round to the nearest whole number. `=ROUND(A2,0)` turns 47.6 into 48. Negative digits round to the left of the decimal. `=ROUND(A2,-1)` rounds to the nearest ten, and `=ROUND(A2,-2)` rounds to the nearest hundred.

Formatting only changes how a number appears. ROUND changes the result used by later formulas. In finance, accounting, school grades, and engineering summaries, that difference matters.

This is why ROUND belongs in the formula only when the rounded value is the rule. If you are preparing a report for readability, formatting may be safer. If a later calculation must use cents, whole units, or nearest tens, ROUND makes that rule explicit.

Practical examples

A beginner example is rounding an average score. If B2 contains 86.6667, `=ROUND(B2,1)` returns 86.7.

A business example is rounding a calculated invoice amount to cents. If D2 contains quantity and E2 contains unit price, `=ROUND(D2*E2,2)` returns the line total rounded to two decimals.

An engineering or operations example is rounding production measurements for reporting. If C2 contains a calculated rate, `=ROUND(C2,0)` returns the nearest whole unit while keeping the rule visible in the formula.

When to use it

Use ROUND when the rounded value should be used in later calculations or shown as a final result. It is appropriate for invoice totals, reported averages, summarized measurements, and clean dashboards.

Do not use ROUND just to make a cell look cleaner. If the underlying value should remain precise, use number formatting instead. Do not use ROUNDUP or ROUNDDOWN unless the business rule specifically requires always rounding in one direction.

Related functions

ROUNDUP always rounds away from zero. ROUNDDOWN always rounds toward zero. INT rounds down to an integer, which is different from ROUNDDOWN for negative numbers. These details matter when handling budgets, quantities, and thresholds.

Practice ROUND on Calcu by comparing displayed formatting with formula-based rounding, then move into ROUNDUP and ROUNDDOWN.