Excel Round Up to Whole Number: Formulas and Examples

Formulas & functions · Updated November 19, 2026

To round a value in Excel up to a whole number, use ROUNDUP with zero decimal places. If the number is in A2, enter =ROUNDUP(A2,0); for example, 4.21 becomes 5. The function rounds away from zero, so a negative value such as -4.21 becomes -5—an important difference from rounding toward positive infinity.

The basic formula and how to enter it

In Microsoft Excel for Microsoft 365 on Windows, place the value to round in a cell, then enter a formula in another cell. The second argument tells Excel how many decimal places to retain. Setting it to zero returns an integer value.

With a number in A2, enter this in B2:

=ROUNDUP(A2,0)

If A2 contains 6.01, B2 returns 7. If A2 contains 6, the result remains 6; ROUNDUP does not add one to numbers that are already whole. To apply the same calculation to a list, enter the formula in the first result row and fill it down using the fill handle at the lower-right corner of the selected cell. Excel adjusts the row reference as the formula is copied.

You can also type a value directly into a formula, but a cell reference is usually easier to maintain when the source data may change. The result is a calculated number, not just a different way of displaying the original value.

What ROUNDUP means, including for negatives

ROUNDUP moves a number away from zero whenever digits must be discarded. For a positive number, that means the result is larger. For a negative number, moving away from zero makes the result smaller in numerical terms. This is why the phrase “round up” can be confusing: it may mean increasing the value toward positive infinity, or it may mean rounding the magnitude upward. ROUNDUP uses the second meaning.

With a value in A2, =ROUNDUP(A2,0) produces 4 for 3.2 and -4 for -3.2. In the negative example, -4 is farther from zero than -3, even though -4 is less than -3. That behavior is useful when a quantity must cover a required magnitude, but it may not match a rule that says to always choose the next integer on the number line.

When the value is already an integer, ROUNDUP leaves it unchanged. Zero also remains zero. These cases matter when a formula is used across a mixed dataset: the function does not force every result to a different integer, but only changes values that have a fractional part at the requested precision.

Examples with positive and negative values

Suppose column A contains measurements and column B should show each measurement rounded to the next whole unit in magnitude. With the first measurement in A2, enter this formula in B2 and copy it down:

=ROUNDUP(A2,0)

  • If A2 is 2.01, the result is 3.
  • If A2 is 2.99, the result is 3.
  • If A2 is 8, the result is 8.
  • If A2 is -2.01, the result is -3.
  • If A2 is -2.99, the result is -3.

For a single illustrative calculation, assume A2 contains 12.4. The formula returns 13 because the nonzero decimal part is discarded by moving the value away from zero. If A2 contains -12.4 instead, the result is -13. Check what the sign means in the real task before applying the formula to negative values; for instance, a negative adjustment or temperature may need a different rounding convention from a count of required items.

ROUNDUP can also retain decimal places rather than returning a whole number. With a value in A2, =ROUNDUP(A2,1) rounds away from zero to one decimal place; 3.41 returns 3.5. A negative second argument rounds to the left of the decimal point. With A2 containing 1234, =ROUNDUP(A2,-2) returns 1300, rounding away from zero to the nearest hundred. This makes the second argument a place-setting control, not a simple on/off switch.

ROUNDUP versus CEILING.MATH

Use ROUNDUP when the requirement is to move away from zero at a chosen decimal position. Use CEILING.MATH when the requirement is to move toward positive infinity to a multiple, including when negative values are possible. For positive numbers, these often appear to do the same thing when rounding to a whole number, but their negative-number behavior differs.

With a number in A2, =CEILING.MATH(A2,1) rounds it up to a multiple of one. For A2 equal to 3.2, the result is 4; for A2 equal to -3.2, the result is -3. The latter is the mathematical ceiling: the smallest integer greater than or equal to the original number. By comparison, ROUNDUP returns -4 for -3.2 because it moves away from zero.

CEILING.MATH also accepts a significance, which sets the multiple to round to. With the value in A2 and a desired multiple of five, =CEILING.MATH(A2,5) rounds 12.1 to 15. ROUNDUP is not a substitute for this multiple-based rule: setting its decimal-place argument to zero only rounds to an integer, not necessarily a multiple such as five or ten. Choose based on the stated rule, rather than on which function sounds most like “round up.”

Rounding the value versus changing its display

Changing a cell’s number format can make a decimal look like a whole number without changing the underlying value. For example, a cell holding 4.7 may display as 5 when formatted with zero decimal places, while formulas that use that cell can still use 4.7. This is useful when the goal is a cleaner report, but it is not the same as calculating a rounded result.

To change the displayed decimal places in Excel for Microsoft 365 on Windows, select the cells and use Home > Number, then choose Decrease Decimal until no decimal places are shown. The exact controls may appear as buttons in the Number group. On Mac, the Home tab also contains number-format controls; on Excel for the web, use the Home tab’s number-format options. The labels and layout can vary slightly by platform or window width.

If later calculations must use the rounded integer, put ROUNDUP in a separate result column and base subsequent formulas on that result. Avoid replacing source data merely to make it look rounded: retaining the original precision can be important for auditing, recalculation, and explaining how a report was produced.

Common problems and how to avoid them

  • Using the wrong negative-number rule: Test a negative example before filling the formula down. If the requirement is mathematical ceiling, use CEILING.MATH rather than ROUNDUP.
  • Rounding a displayed value rather than the stored value: Number formatting changes appearance only. Use a formula when downstream calculations need the rounded result.
  • Using a text value: A cell that contains a number stored as text may not behave like a numeric input. Check for imported data, leading apostrophes, or inconsistent separators, then convert the source to numbers as appropriate.
  • Including units or other text in the input cell: A value such as a number followed by a typed unit is text, not a plain numeric value. Keep the number in its own cell and put the unit in a separate column or apply a suitable number format.
  • Expecting ROUNDUP to add one to an integer: If the input is already whole, it stays as it is. The function only changes a value when there are digits beyond the requested precision.
  • Copying the formula incorrectly: When filling down, verify that each formula refers to the corresponding source row. If the data is in a different column, update the cell reference rather than copying the example unchanged.

If Excel shows an error, check that the referenced cell exists and contains a usable number. Also check the formula’s separators: the examples here use commas, as requested for standard Excel formula syntax, although regional settings can affect which list separator Excel accepts in a particular installation.

Choosing the right method for the job

Before choosing a function, decide what “up” means in the context of the data, and whether the rounded result must feed later calculations. These questions usually settle the choice:

  1. Must the result move away from zero? Choose ROUNDUP. This is common for positive quantities where a partial unit requires one more whole unit.
  2. Must the result be the next integer at or above the input? Choose CEILING.MATH with a significance of one. This gives the mathematical ceiling for positive and negative inputs.
  3. Must the result be a multiple? Use a ceiling function with the required significance, such as five or ten, rather than simply rounding to zero decimal places.
  4. Is this only for presentation? Change the number format instead of changing the data used in calculations.
  5. Should ordinary nearest-number rounding apply? Use ROUND, not ROUNDUP. ROUND follows its own midpoint rule and can produce a different answer.

For practical planning, rounding a positive count upward can prevent a shortfall. If a task needs 21.2 whole packages, for example, the result must be 22 packages. For measurements, billing, or scientific reporting, however, the required standard may specify a particular precision or rounding convention. The spreadsheet function should follow that rule; it should not decide the rule for you.

Frequently Asked Questions

How do I round up to a whole number in Excel?
With the value in A2, enter =ROUNDUP(A2,0) in another cell. A value of 5.1 returns 6, while an exact 5 remains 5.

Does ROUNDUP always make a number larger?
No. ROUNDUP moves away from zero. It increases positive values that have decimals, but makes negative values more negative. For negative inputs that must round toward positive infinity, use CEILING.MATH with a significance of one.

What is the difference between ROUND and ROUNDUP?
ROUND rounds to the nearest value at the specified precision, while ROUNDUP moves away from zero whenever it removes digits. With A2 set to 2.1, ROUND to zero decimal places returns 2, whereas ROUNDUP returns 3.

Can I round up to the nearest ten instead?
Yes. With the value in A2, =ROUNDUP(A2,-1) rounds away from zero to the nearest ten; 121 returns 130. For rules involving negative numbers or a more specific multiple, consider whether CEILING.MATH better matches the intended direction.

Why does the cell look rounded but still calculate with decimals?
The cell may only be formatted to display zero decimal places. Formatting changes what you see, not the stored value. Use ROUNDUP in a formula when subsequent calculations need to use the rounded result.

Takeaway

For the common case of rounding a value away from zero to an integer, use ROUNDUP with zero decimal places. Check negative inputs carefully, because “up” can mean different things; use CEILING.MATH when the intended result is the next integer toward positive infinity. If only the display needs to look whole, change the number format instead of altering the calculation.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.