Excel ROUND/ROUNDUP/ROUNDDOWN Functions

last modified October 5, 2026

The ROUND, ROUNDUP, and ROUNDDOWN functions are essential for number formatting in Excel. They control decimal precision and rounding direction. This tutorial provides a comprehensive guide to using these functions with detailed examples. You will learn the syntax and arguments, how each function treats ties and negative numbers, what happens when num_digits is negative, and how the three functions compare with MROUND, CEILING, and FLOOR.

ROUND Functions Basics

Excel offers three main rounding functions that differ in their rounding behavior. Each serves specific purposes in financial, scientific, and data analysis applications.

Function	Description	Syntax
ROUND	Rounds to the nearest value; ties round away from zero	=ROUND(number, num_digits)
ROUNDUP	Rounds away from zero	=ROUNDUP(number, num_digits)
ROUNDDOWN	Rounds toward zero	=ROUNDDOWN(number, num_digits)

This table compares the three rounding functions. All take a number and digit count as arguments but differ in rounding direction. The directions are the ones defined by Microsoft: ROUNDUP rounds a number up, away from zero, and ROUNDDOWN rounds a number down, toward zero. ROUND settles between them by rounding to the nearest value. Understanding these differences is crucial for accurate calculations.

Component	Description
Function Name	ROUND, ROUNDUP, ROUNDDOWN
Syntax	=ROUND(number, num_digits)
Arguments	number - the value to round num_digits - the number of digits to round to
Return Value	The rounded number

This table breaks down the essential components shared by the three functions. It shows the function name, basic syntax format, argument requirements, and return value characteristics. ROUNDUP and ROUNDDOWN accept the same two arguments in the same order, so you can switch between them without changing the rest of a formula.

Argument	Meaning
number	The value you want to round. It can be a literal, a cell reference, or an expression that returns a number, such as A1-B1. Text that looks like a number is converted; other text returns #VALUE!.
num_digits	Required. The number of digits to round to. Positive values count decimal places to the right, zero rounds to the nearest integer, and negative values count positions to the left of the decimal point.

All three functions take exactly two arguments, and both are required. Omitting num_digits makes Excel report that too few arguments were entered. The value of num_digits selects the position of the last kept digit. Excel's own guidance is concise: if num_digits is greater than 0, the number is rounded to that many decimal places; if it is 0, the number is rounded to the nearest integer; if it is less than 0, the number is rounded to the left of the decimal point.

Basic ROUND Example

This example demonstrates the standard rounding behavior with a positive number.

=ROUND(3.14159, 2)

This formula rounds pi to 2 decimal places. The result will be 3.14. ROUND rounds to the nearest value, and an exact half is rounded away from zero, so a trailing 5 pushes the previous digit up in magnitude. Microsoft's own examples show =ROUND(2.15, 1) returning 2.2, while =ROUND(2.149, 1) returns 2.1 because 2.149 is not a tie.

=ROUND(2.5, 0)   ' 3
=ROUND(3.5, 0)   ' 4
=ROUND(-2.5, 0)  ' -3
=ROUND(-3.5, 0)  ' -4

Ties move away from zero in both directions, which keeps the rule symmetric: positive halves round to the next higher integer and negative halves to the next lower integer. Ordinary values follow nearest-value rounding, as in =ROUND(1.9, 0) returning 2 and =ROUND(-1.9, 0) returning -2. This makes ROUND the right default for general rounding needs.

ROUNDUP for Conservative Estimates

ROUNDUP always rounds away from zero, useful for conservative calculations like material requirements.

A	B
7.231
	=ROUNDUP(A1, 1)

The table shows ROUNDUP rounding 7.231 up to one decimal place. The next digit (3) would normally leave the value at 7.2, but ROUNDUP forces the first decimal place up regardless of what follows it.

=ROUNDUP(7.231, 1)

This formula rounds 7.231 up to 7.3 at one decimal place. The result exceeds the original value, ensuring you don't underestimate in critical calculations. Because ROUNDUP always moves away from zero, the same rule holds for negative values: =ROUNDUP(-3.14159, 1) returns -3.2, which is further from zero than the input.

ROUNDDOWN for Maximum Allowable Values

ROUNDDOWN always rounds toward zero, useful when you must stay below limits like budget ceilings.

A	B
15.987
	=ROUNDDOWN(A1, 0)

The table demonstrates ROUNDDOWN truncating 15.987 to an integer. Despite being close to 16, it rounds down to 15, ensuring you don't exceed the integer limit.

=ROUNDDOWN(15.987, 0)

This formula rounds 15.987 down to 15 when specifying 0 decimal places. The result never exceeds the original value in magnitude, enforcing strict upper limits. For negative inputs the same direction applies toward zero: =ROUNDDOWN(-1.9, 0) returns -1 rather than -2.

Rounding with Negative num_digits

A negative num_digits rounds to the left of the decimal point. This example shows rounding to the hundreds place.

=ROUND(2745, -2)

This formula rounds 2745 to the nearest hundred. The result is 2700. With a num_digits of -2, Excel works two positions to the left of the decimal point and uses the tens digit to decide: the tens digit is 4, which is below 5, so the hundreds digit stays at 2.

Formula	Result	Rounding Position
=ROUND(1234.5678, -1)	1230	Nearest ten
=ROUND(1234.5678, -2)	1200	Nearest hundred
=ROUND(1234.5678, -3)	1000	Nearest thousand
=ROUND(1234.5678, -4)	0	Nearest ten thousand
=ROUND(21.5, -1)	20	Nearest ten
=ROUNDUP(31415.92654, -2)	31500	Up to the nearest hundred
=ROUNDDOWN(31415.92654, -2)	31400	Down to the nearest hundred

Each formula rounds at a power of ten instead of at a decimal place. ROUND(1234.5678, -4) returns 0 because 1234.5678 is closer to 0 than to 10000; only a value of 5000 or more produces 10000, and =ROUND(4999, -4) still returns 0. The same logic makes =ROUND(2.5, -1) return 0, because 2.5 is closer to 0 than to 10. The last two rows show that negative num_digits works with ROUNDUP and ROUNDDOWN as well, so you can force a value up or down at the hundreds or thousands level.

Negative Numbers and Rounding Direction

ROUNDUP and ROUNDDOWN do not follow the number line; they follow the distance from zero. On negative numbers this means ROUNDUP produces a value that looks smaller and ROUNDDOWN a value that looks larger. The table rounds several numbers to zero decimal places with each function.

Number	ROUND(number, 0)	ROUNDUP(number, 0)	ROUNDDOWN(number, 0)
2.5	3	3	2
-2.5	-3	-3	-2
1.9	2	2	1
-1.9	-2	-2	-1
-1.1	-1	-2	-1

=ROUNDUP(-1.1, 0)   ' -2, away from zero
=ROUNDDOWN(-1.9, 0) ' -1, toward zero
=ROUND(-2.5, 0)     ' -3, half away from zero

Note that ROUNDUP(-1.1, 0) returns -2, which is numerically less than -1.1: "up" means greater magnitude, not further along the number line. ROUNDDOWN moves toward zero, so ROUNDDOWN(-1.9, 0) returns -1 and the result never exceeds the original magnitude. ROUND treats both signs the same way and rounds ties away from zero, which is why it is the default choice for general work.

Comparing All Three Functions

This example demonstrates how all three functions handle the same number differently at the same number of decimal places.

Value	ROUND	ROUNDUP	ROUNDDOWN
9.8765	9.88	9.88	9.87
-9.8765	-9.88	-9.88	-9.87

=ROUND(A1, 2)      ' 9.88
=ROUNDUP(A1, 2)    ' 9.88
=ROUNDDOWN(A1, 2)  ' 9.87

The table clearly shows the different behaviors: ROUND follows standard rules, ROUNDUP increases the magnitude, and ROUNDDOWN decreases it. The second row confirms that the same directions hold for negative values. All three formulas use 2 decimal places, so only the rounding direction changes between the columns.

Financial Rounding with ROUND

ROUND is essential in financial calculations where specific decimal precision is required for currency values.

=ROUND(Subtotal*TaxRate, 2)

This formula calculates tax and rounds to 2 decimal places (cents). Using ROUND ensures proper monetary values without fractional cents in financial reporting.

Engineering Rounding with ROUNDUP

ROUNDUP ensures safety factors in engineering by always rounding up material requirements.

=ROUNDUP(RequiredLength/PieceLength, 0)

This formula calculates how many pieces are needed and rounds up. Even if 0.1 pieces are needed, ROUNDUP ensures you get 1, preventing under-supply in engineering projects.

Statistical Rounding with ROUNDDOWN

ROUNDDOWN is useful in statistics when you need conservative estimates or integer counts.

=ROUNDDOWN(AVERAGE(DataRange), 1)

This formula calculates an average and rounds down to one decimal place. ROUNDDOWN provides conservative estimates in statistical analysis, preventing overestimation of results.

ROUND vs MROUND, CEILING, and FLOOR

Excel provides three more rounding tools that work with multiples instead of digit counts. MROUND rounds to the nearest multiple, CEILING rounds up to the next multiple, and FLOOR rounds down to the previous multiple. The table shows typical uses of both families.

Goal	Formula	Result
Round 2.5 to the nearest integer	=ROUND(2.5, 0)	3
Round 13 to the nearest multiple of 5	=MROUND(13, 5)	15
Round 11 up to a multiple of 5	=CEILING(11, 5)	15
Round 11 down to a multiple of 5	=FLOOR(11, 5)	10
Round a price up to the nearest nickel	=CEILING(4.42, 0.05)	4.45
Round 9.811 up to 2 decimals	=ROUNDUP(9.811, 2)	9.82
Round 9.899 down to 2 decimals	=ROUNDDOWN(9.899, 2)	9.89

For positive numbers the multiple-based functions mirror the digit-based ones: CEILING matches ROUNDUP, FLOOR matches ROUNDDOWN, and MROUND matches ROUND because it rounds to the nearest multiple and moves ties away from zero, as in =MROUND(10, 3) returning 9. Two sign rules are worth remembering. MROUND requires the number and the multiple to have the same sign, otherwise it returns #NUM!, as in =MROUND(5, -2), and FLOOR returns #NUM! when the number is positive and the significance is negative. Microsoft also documents that ties with decimal multiples are not reliable: =MROUND(6.05, 0.1) returns 6.0 while =MROUND(7.05, 0.1) returns 7.1, so avoid exact ties when the multiple is a decimal value.

Use the digit-based functions when you control the number of decimal places, and reach for the multiple-based ones when the target is a physical or financial step such as 0.05, 0.5, or 5. CEILING is the usual choice for prices and pack sizes that must not be undershot, while FLOOR fits budget caps and container limits.

ROUND Errors and Troubleshooting

Cause	Symptom	Fix
number contains text that cannot be converted	#VALUE! error	Test with ISNUMBER or convert with VALUE
num_digits contains non-numeric text	#VALUE! error	Pass a number; numeric text such as "2" is accepted
num_digits argument omitted	Excel reports too few arguments	Both arguments are required
Referenced cell is empty	The result is 0	Empty cells are treated as zero; guard with IF
num_digits greater than 15	No extra digits appear in the result	Excel keeps 15 significant digits, so 15 is the practical maximum
Rounding a negative number with ROUNDUP	ROUNDUP(-1.1, 0) returns -2, a lower value	ROUNDUP moves away from zero; use ROUND or ROUNDDOWN instead
Underlying value is already an error	The same error is passed through	ROUND cannot mask #N/A, #DIV/0!, or similar errors; wrap the formula with IFERROR

The ROUND, ROUNDUP, and ROUNDDOWN functions provide precise control over numeric precision in Excel, and their directions are easy to remember: ROUND moves to the nearest value with ties away from zero, ROUNDUP always moves away from zero, and ROUNDDOWN always moves toward zero. The same three rules apply at every position selected by num_digits, including positions left of the decimal point, and they apply unchanged to negative numbers. When the target is a multiple rather than a digit count, MROUND, CEILING, and FLOOR follow the same directions. Choose the function that matches your rounding policy, watch the sign rules for negative values, and your spreadsheets will return accurate, predictable results every time.

Author

My name is Jan Bodnar, and I am a passionate programmer with extensive programming experience. I have been writing programming articles since 2007. To date, I have authored over 1,400 articles and 8 e-books. I possess more than ten years of experience in teaching programming.

List all Excel Formulas.