Roundup Excel Cell Values: 10 Ways to Round Numbers

To round a number up to the next whole number in Excel, with the value in A2, enter =ROUNDUP(A2,0); for example, 2.31 returns 3. This roundup covers formulas, multiples, negative numbers, Power Query, and display formatting for people who need rounded spreadsheet values without confusing a changed result with a number that is merely shown differently.

1. Use ROUNDUP for a whole-number result

With the number 2.31 in A2, enter =ROUNDUP(A2,0); it returns 3 because the second argument, 0, asks Excel to round to zero decimal places. ROUNDUP moves a nonzero value away from zero, so 2.01 becomes 3 rather than 2, while an already whole number such as 4 stays 4. This is a straightforward choice for quantities that must not understate a count, such as packages needed when a shipment contains fractional box quantities. The result remains numeric, so it can be used in later arithmetic, sorting, and charts.

2. Keep a chosen number of decimal places

With 2.341 in A2, use =ROUNDUP(A2,2) to return 2.35, keeping two decimal places while rounding any discarded nonzero digits upward in magnitude. Change the second argument to 1 for tenths or 3 for thousandths; for example, the same value rounded to three places becomes 2.342. This is useful for rates, measurements, and estimates when a consistent displayed precision is required and ordinary rounding could leave a value below the source. Remember that ROUNDUP does not mean “round only when the next digit is 5 or more”: even 2.341 rounds to 2.35 at two places.

3. Round up to tens, hundreds, or larger place values

With 146 in A2, enter =ROUNDUP(A2,-1) to get 150, or use -2 to round up to the nearest hundred, producing 200. A negative num_digits value tells ROUNDUP to work to the left of the decimal point, while a positive value works to the right. This is practical for rough capacity planning, order quantities, or estimates that must be expressed in broad increments. For negative inputs, the function still rounds away from zero: -146 rounded with -1 becomes -150, so it does not mean “toward the larger number” in the mathematical sense.

4. Round up to a specified multiple with CEILING.MATH

With 1.11 in A2 and a required increment of 0.25, enter =CEILING.MATH(A2,0.25) to return 1.25, the next quarter-unit boundary. The second argument is the significance, or step size, rather than a count of decimal places; changing it to 5 rounds a positive 12.1 up to 15. This makes CEILING.MATH a useful fit for billing increments, pack sizes, and materials ordered in fixed lengths, where a decimal-place formula alone does not express the rule. CEILING.MATH is available in Excel 2013 and later, including Microsoft 365, and its optional mode argument can control how negative values are treated.

5. Use CEILING when supporting older workbooks

With a positive value of 12.1 in A2 and a step size of 5, enter =CEILING(A2,5) to return 15. CEILING is an established function that is often useful when a workbook must remain compatible with older Excel installations, while CEILING.MATH offers clearer behavior for negative values in newer releases. Keep the number and significance positive for this common use, and avoid relying on CEILING for mixed-sign inputs because its sign rules can produce an error. If the sheet handles refunds, credits, or negative measurements, choose CEILING.MATH deliberately and verify the intended direction with a test value before copying the formula throughout the workbook.

6. Understand ROUNDUP with negative values

With -2.31 in A2, enter =ROUNDUP(A2,0) to return -3; Excel rounds away from zero, not toward positive infinity. That distinction matters when “up” in a business instruction means increasing the magnitude, such as rounding a negative adjustment conservatively, but it may be wrong when the instruction means the next higher number on a number line. Test a positive and a negative sample before applying the function to mixed data. If you want the mathematical ceiling of -2.31, which is -2, use a ceiling calculation instead of ROUNDUP.

7. Calculate the mathematical ceiling for signed data

With -2.31 in A2, use =-INT(-A2) to return -2, the smallest integer greater than or equal to the value; with 2.31 in A2, the same formula returns 3. INT rounds its argument down to an integer, and reversing the sign before and after that operation creates the mathematical ceiling behavior for positive and negative decimal values. This can help when assigning signed measurements to integer bands or when “round up” specifically means move toward positive infinity. It differs from ROUNDUP for negative inputs, so label the rule clearly in a worksheet and do not substitute it for away-from-zero rounding without checking the business requirement.

8. Apply ROUNDUP down a column, then keep the results

With source values in A2:A5, enter =ROUNDUP(A2,0) in B2, then fill the formula down through B5; if the source values are 2.1, 4, -2.1, and 0, the results are 3, 4, -3, and 0. Excel adjusts the relative reference as the formula is filled, so the next row uses A3, then A4, and so on. Keeping the rounded output in a separate column preserves the original measurements and makes review easier. If you need to replace the formulas with fixed numeric results, copy the output cells and use Home > Paste > Paste Values; retain a copy of the original data first because the values-only paste removes the formulas.

9. Round a data column up in Power Query

For a repeatable import-cleaning workflow, select a cell in the source table and choose Data > From Table/Range to open the Power Query Editor. Select the numeric column, then choose Transform > Rounding > Round Up and set the number of decimal places in the dialog; for a source value of 2.341 rounded to two places, the result is 2.35. Power Query records the transformation as a step, so refreshing the query applies the same rule to new rows rather than requiring a copied worksheet formula. This is especially useful for recurring CSV or database imports, but it changes the query output rather than directly editing the original source file; Power Query authoring and connector support can differ on Mac and is not equivalent to the full Windows editor in Excel for the web.

10. Format the display when the underlying value should stay exact

If A2 contains 2.341 and you only need the cell to show two decimal places, select the cell and use Home > Number to reduce the displayed decimal places, or open Format Cells and set Decimal places to 2. The cell may display 2.34, but the stored value remains 2.341, so later formulas continue to calculate from the full value unless workbook settings or a formula change it. This is the right option for cleaner reports when precision should be preserved, but it is not a way to make a genuinely rounded numeric result. Check the formula bar or use the value in a calculation if you need to distinguish what is stored from what is visible.

How to Choose

Start by defining what “up” means in the task. If it means move away from zero, use ROUNDUP; if it means reach the next multiple, use CEILING.MATH; if it means the next integer toward positive infinity for signed values, use a ceiling calculation such as =-INT(-A2). Then decide whether the target is a number of decimal places, a place value such as tens, or a step size such as 0.25, because those rules call for different arguments and formulas.

Next, decide whether the underlying value should change. A formula or a Power Query transformation creates rounded output that downstream calculations can use, while number formatting changes only what the cell displays. For an auditable workbook, keep the original input beside the rounded result and label both columns. For recurring imports, Power Query can avoid repeating manual cleanup; for a small live calculation, a worksheet formula is usually simpler. Finally, test boundary cases—including a value already on the boundary, a value just above it, zero, and a negative value—before filling the rule across the full dataset.

Frequently Asked Questions

Does ROUNDUP always move a number to the next integer?

It rounds away from zero at the precision you specify, but it does not necessarily change a value. For example, with 4 in A2, =ROUNDUP(A2,0) returns 4; with 4.01, it returns 5.

What is the difference between ROUNDUP and CEILING.MATH?

ROUNDUP sets precision by decimal places or place values, such as two decimals. CEILING.MATH rounds to a multiple, such as the next 0.25 or 5, and provides options for negative-number behavior.

Why does ROUNDUP turn -2.31 into -3?

ROUNDUP moves numbers away from zero. If you mean the next integer toward positive infinity, use a mathematical ceiling approach, which gives -2 for -2.31.

Can I round a value without changing its stored precision?

Yes. Apply number formatting to control the displayed decimal places; the underlying value remains available to formulas. Use a rounding formula when later calculations must use the rounded result itself.

Can Excel round up an entire imported column automatically?

Yes. In the Windows Power Query Editor, apply Transform > Rounding > Round Up to the selected numeric column, then refresh the query when the source data changes. Check the available Power Query features on Mac or Excel for the web before depending on the same workflow there.

Final Thoughts

For a basic whole-number result, ROUNDUP is the clearest starting point, but the right choice depends on whether you mean away from zero, to a multiple, or toward positive infinity. Keep formatting separate from actual rounding, test negative and boundary values, and preserve source data when replacing formulas with fixed results. Those checks make rounded outputs easier to trust and maintain.

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.