Advanced Excel, Excel
Oct 6, 2026
How to Use the Excel ROUND Function and Other Rounding Formulas
Key Takeaways
The ROUND function in Excel rounds a number to a specified number of decimal places using the syntax ROUND(number, num_digits).
ROUNDUP and ROUNDDOWN let you control rounding direction, while MROUND rounds to the nearest multiple of a value you choose.
Cell formatting only changes how a number displays, but an Excel rounding formula changes the actual stored value used in calculations.
ODD, EVEN, CEILING and FLOOR provide additional rounding options for specialized needs.
What Is the Excel ROUND Function?
The Excel ROUND function is one of the most commonly used tools for controlling how numbers appear and behave in your spreadsheets. It rounds a number to a specified number of decimal places using the syntax ROUND(number, num_digits). The first argument, number, is the value you want to round. The second argument, num_digits, tells Excel how many decimal places to include in the result.
If you need to learn how to round in Excel, it helps to understand that the ROUND function is just one member of a larger family of rounding functions. Excel also offers ROUNDUP, ROUNDDOWN, MROUND, CEILING, FLOOR, ODD and EVEN, each designed for different rounding scenarios.
One important distinction to keep in mind is the difference between cell formatting and formula-based rounding. When you format a cell to display fewer decimal places, the number on screen changes but the underlying stored value remains the same. That full-precision value is still used in any calculations that reference the cell. When you use the round function in Excel, the actual stored value changes to the rounded result. This matters when precision in downstream formulas is critical.
When to Use the ROUND Function
Many practical situations call for an Excel rounding formula to help you work more efficiently and present cleaner data. Here are a few common use cases:
Financial reports: Rounding currency values to two decimal places ensures invoices, budgets and financial statements display consistent figures. Rounding is frequently combined with Excel finance formulas to maintain precision in financial workbooks.
Dashboards and summaries: Simplifying large numbers by rounding to the nearest hundred or thousand makes charts and summary tables easier to read.
Data consistency: When combining data from multiple sources, applying the round function in Excel ensures uniform decimal precision across your entire dataset. Pairing rounding with conditional formatting can help you visually flag inconsistencies that remain.
Pricing and invoicing: Rounding calculated prices to standard increments (such as the nearest five or 10 cents) keeps pricing clean and professional.
ROUND, ROUNDUP and ROUNDDOWN Functions
ROUND is a basic rounding function that rounds a number to the nearest value at a specified decimal place. A formula using the ROUND function is formatted as ROUND(x,y) where x is the number to be rounded and y is the number of decimal places to round to. A y value of zero rounds the number to the nearest integer. A positive value for y rounds the number to that many digits after the decimal point. A negative value for y rounds to digits before the decimal point (e.g., -1 rounds to the nearest 10, -2 rounds to the nearest 100).
For example, the formula "=ROUND(123.456,-2)" results in a value of 100 while "=ROUND(123.456,2)" results in a value of 123.46.
If you want to consistently round up, use the ROUNDUP function instead of ROUND. ROUNDUP always rounds away from zero, using the same syntax as ROUND. To always round down, use the ROUNDDOWN function instead, which rounds toward zero.
MROUND Function
Sometimes you may need to round to a particular multiple like five or 25. To do this, employ the MROUND function in your formula. This function rounds numbers to a designated multiple in the format MROUND(x,y) where x is the number to be rounded and y is multiple to round to.
For cases where you need to consistently round down to a multiple, use the FLOOR function. To always round up to a multiple, use the CEILING function. Both follow a similar syntax to MROUND.
ODD and EVEN Functions
One more set of functions may help when you create a rounding formula. The ODD and EVEN functions round a value to nearest odd or even integer, respectively. For instance, =ODD(4.3) returns 5 and =EVEN(4.3) returns 6.
Excel Rounding Functions at a Glance
The table below summarizes the key rounding functions available in Excel, their syntax and what each one does.
Function | Syntax | What It Does | Example |
|---|---|---|---|
ROUND | ROUND(number, num_digits) | Rounds to a specified number of decimal places | =ROUND(3.456, 2) returns 3.46 |
ROUNDUP | ROUNDUP(number, num_digits) | Always rounds away from zero | =ROUNDUP(3.421, 2) returns 3.43 |
ROUNDDOWN | ROUNDDOWN(number, num_digits) | Always rounds toward zero | =ROUNDDOWN(3.789, 2) returns 3.78 |
MROUND | MROUND(number, multiple) | Rounds to the nearest multiple of a specified value | =MROUND(17, 5) returns 15 |
CEILING | CEILING(number, significance) | Rounds up to the nearest multiple of a specified value | =CEILING(4.2, 5) returns 5 |
FLOOR | FLOOR(number, significance) | Rounds down to the nearest multiple of a specified value | =FLOOR(17, 5) returns 15 |
ODD | ODD(number) | Rounds up to the nearest odd integer | =ODD(4.3) returns 5 |
EVEN | EVEN(number) | Rounds up to the nearest even integer | =EVEN(4.3) returns 6 |
INT | INT(number) | Rounds down to the nearest integer | =INT(7.9) returns 7 |
TRUNC | TRUNC(number, num_digits) | Truncates a number to a specified number of digits without rounding | =TRUNC(7.986, 1) returns 7.9 |
Common Rounding Issues and How to Fix Them
Even experienced spreadsheet users run into unexpected rounding behavior. Here are two of the most common problems and how to resolve them.
Excel rounding incorrectly due to floating-point precision: Excel stores numbers in binary floating-point format, which can introduce tiny precision errors when converting between decimal and binary systems. For example, a formula that should return exactly 0.1 might store a value like 0.09999999999999998. To correct this, apply the ROUND function to force the result to the number of decimal places you need. For instance, wrapping a SUM formula in ROUND eliminates the small discrepancies caused by binary storage.
Excel appears to round numbers you did not intend to round: If numbers look rounded in your cells but you did not apply a rounding formula, the issue is usually display-related. A narrow column may not have enough space to show all digits, causing Excel to truncate the visible number. Widen the column to reveal the full value. You can also check whether cell formatting is limiting visible decimal places by right-clicking the cell, selecting Format Cells and adjusting the Decimal Places setting under the Number tab. Remember that the Increase Decimal and Decrease Decimal buttons in the Number group on the Home ribbon only change how the number is displayed, not the stored value. To stop Excel from rounding the actual value, use the ROUND function with enough decimal places to preserve the precision you need.
Build Your Excel Skills with Pryor Learning
Mastering rounding functions is one important step toward becoming proficient in Excel. There are multiple ways to produce the same results, so don't be afraid to experiment with these functions to create the Excel rounding formula that works for you.
Pryor Learning offers Excel training courses designed for every skill level, from beginner fundamentals to advanced formulas and data analysis. Training is available in formats that fit your schedule:
Live seminars: Instructor-led sessions covering core Excel skills in a structured, interactive setting
On-demand courses: Self-paced training you can access anytime through PryorPlus
Onsite training: Customized group sessions delivered at your workplace
