ROUND Function

Summary

The Excel ROUND function rounds a number to a specified number of digits. It is the standard worksheet function for numerical precision when the result itself must be rounded, not merely formatted to look rounded.

This distinction matters because cell formatting does not change the stored value. A number may display as 3.14 while Excel still stores a longer decimal internally. ROUND changes the actual result used in later calculations, which is why it is often applied in financial models, reports, and intermediate calculations where displayed precision and stored precision need to match.

ROUND is useful because many worksheet results need to be cleaner than the raw calculation. It helps the workbook present values at the right precision for reporting, pricing, or display while still keeping the logic more explicit than relying on formatting alone.

Syntax

=ROUND(number, num_digits)

Microsoft documents two required arguments. number is the value to round, and num_digits determines where the rounding occurs.

Arguments

• number - [required] The value or formula result to round.
• num_digits - [required] The number of digits to keep.

If num_digits is greater than 0, Excel rounds to that many decimal places. If it is 0, Excel rounds to the nearest integer. If it is less than 0, Excel rounds to the left of the decimal point.

ROUND vs Related Rounding Functions

Using ROUND

ROUND is most appropriate when the result should follow standard mathematical rounding rather than a forced upward or downward rule. That makes it a good default when presenting calculated values, currency figures, averages, rates, or summary statistics that need a defined number of decimal places.

It is also useful after a larger formula rather than only on raw inputs. For example, =ROUND(SUM(A1:A10),2) rounds the final sum, which is often the appropriate place to apply reporting precision. In other models, you may instead round each row before summing if each row is expected to behave as an independently rounded amount. The placement of ROUND therefore affects both presentation and arithmetic.

Negative values of num_digits are often overlooked, but they are important in reporting. They allow you to round to tens, hundreds, or thousands, which is useful when exact low-order digits distract from the scale of the result rather than clarify it.

Example 1 - Round to Two Decimal Places

This is the standard decimal-precision case.

=ROUND(B1,2)

If B1 contains 3.14159, the result is 3.14. This is the common pattern for currency, rates, ratios, and any value where a fixed decimal precision is part of the specification.

Example 2 - Round to the Nearest Integer

Use 0 as the digit argument when the decimal portion should not remain in the final result.

=ROUND(B2,0)

If B2 contains 7.6, the result is 8. Microsoft's standard rule applies here: values with a discarded digit of 5 or more round upward to the next integer.

Example 3 - Round to the Nearest 10

Negative digit values move the rounding position left of the decimal point.

=ROUND(B3,-1)

If B3 contains 256, the result is 260. This is useful in summary reporting, forecast presentation, or high-level planning where exact units are less important than scale.

Example 4 - Make the Precision Dynamic

The rounding rule can be stored in the worksheet rather than hardcoded into the formula.

=ROUND(B4,C4)

If B4 contains 9.9876 and C4 contains 2, the result is 9.99. Using a cell reference for the precision makes the model easier to adjust when report requirements change.

Microsoft's examples also show that ROUND behaves consistently with negative numbers, including when the rounding position is to the left of the decimal point. That matters in ledger-style data and variance analysis where both positive and negative values appear in the same measure.

• ROUND changes the stored result, not just the display format.
• Positive, zero, and negative digit arguments each have distinct uses.
• The placement of ROUND inside a larger formula can materially affect totals.

Conclusion Recap

ROUND is the standard choice when you want normal rounding without forcing the answer up or down. This lesson showed that the second argument controls where the rounding happens, whether that is decimal places, whole numbers, or bigger place values like tens and hundreds.

The most useful beginner takeaway is that ROUND changes the real result, not just how the number looks on screen. That makes it important in formulas where later calculations should use the rounded value too, not the longer hidden decimal.

• Summary: ROUND rounds a number to a specified number of digits.
• Primary use: Standard rounding with controlled precision.
• Key flexibility: Negative digit values round to tens, hundreds, and higher place values.
• Main distinction: ROUND affects the value itself, not only its formatting.
• Function choice: Use ROUND when neither an upward nor downward bias is required.