To round a number up in Excel, use =ROUNDUP(number,num_digits); for example, with a value in A2, =ROUNDUP(A2,2) rounds it away from zero to two decimal places. The ten methods below cover everyday decimal rounding, negative numbers, multiples, times, significant figures, and totals, for anyone who needs calculated values—not just displayed values—to follow a rounding rule.
1. Use ROUNDUP for ordinary decimal rounding
With the number 8.241 in A2, enter =ROUNDUP(A2,2); the result is 8.25. ROUNDUP takes two arguments: the number or cell to process, and how many digits to retain, with positive digits counting decimal places. Unlike ROUND, it always moves the result away from zero, so the same formula applied to -8.241 returns -8.25, not -8.24; that behavior matters when working with costs, measurements, or thresholds that must not be understated.
2. Round up to the next whole number
With a decimal value in A2, use =ROUNDUP(A2,0); if A2 is 6.01, the result is 7, while 6 remains 6. A zero in the second argument means no decimal places, so any nonzero fractional part pushes a positive number to the next integer. Negative values also move away from zero: -6.01 becomes -7, which is different from the everyday phrase “up to the next number” if you mean a larger value on the number line.
3. Keep a chosen number of decimal places
With a measurement or price in A2, use =ROUNDUP(A2,3) to retain three decimal places; for 4.1201, Excel returns 4.121. Change the second argument to 1 for tenths, 2 for hundredths, or another nonnegative integer for the precision you need. This is useful when a specification requires a minimum precision, but it does not force Excel to show trailing zeros: apply a number format with the desired decimal places if 4.120 needs to display as 4.120 rather than 4.12.
4. Round up to the next ten
With a whole-number value in A2, enter =ROUNDUP(A2,-1); 126 becomes 130, and 120 stays 120. A negative digit tells ROUNDUP to work to the left of the decimal point, so -1 means tens. This can simplify rough capacity estimates or grouped counts, but remember the away-from-zero rule: -126 becomes -130, not -120, and a value already on a multiple of ten remains unchanged.
5. Round up to the next hundred
With a number in A2, use =ROUNDUP(A2,-2); 1,234 returns 1,300, while 1,200 remains 1,200. Here, -2 specifies hundreds, just as -1 specifies tens; -3 would round to thousands. This approach is useful for planning a rounded-up allowance or presenting a large count at a consistent scale, but it changes the underlying result, so keep the original value available if readers need exact figures.
6. Round up to a decimal increment with CEILING.MATH
With a positive price in A2, use =CEILING.MATH(A2,0.05); a value of 12.31 becomes 12.35, the next multiple of five cents. ROUNDUP controls decimal places, whereas CEILING.MATH rounds to a specified significance, making it a better fit for increments such as 0.05, 0.25, or 2.5. Format the result as currency if appropriate; the formula itself returns a number, and formatting changes only how that number appears. For negative values, CEILING.MATH’s default behavior differs from ROUNDUP and rounds toward zero, so check the intended rule before applying it to credits or adjustments.
7. Round a quantity up to a pack size
With a positive required quantity in A2 and a pack size of 12, enter =CEILING.MATH(A2,12); a requirement of 25 returns 36, enough for three full packs. This is handy for cartons, bundles, or production batches because the significance argument represents the actual pack multiple, not the number of digits. If the quantity is already 24, the result stays 24, so Excel does not add an unnecessary pack when the requirement divides evenly.
8. Round a time up to the next 15 minutes
With an Excel time in A2, use =CEILING.MATH(A2,TIME(0,15,0)); 9:07 becomes 9:15, and 9:30 stays 9:30. Excel stores times as fractions of a day, and TIME(0,15,0) supplies a quarter-hour interval in that same system. Format the result as a time such as h:mm; for elapsed durations that can exceed 24 hours, use the custom format [h]:mm so the display does not restart at zero after a day. This gives a rounded time value for scheduling or recording intervals, rather than text that only looks rounded.
9. Round up to a number of significant figures
With a numeric value in A2, use =IF(A2=0,0,ROUNDUP(A2,2-INT(LOG10(ABS(A2))))) to round up to three significant figures; 1,234 becomes 1,240 and 0.01234 becomes 0.0124. The formula finds the value’s order of magnitude, then calculates how many decimal places ROUNDUP needs, while ABS and the zero check handle negative inputs and zero. This is useful for scientific or engineering data where significant figures matter more than a fixed number of decimal places; the result for -1,234 is -1,240 because ROUNDUP moves away from zero.
10. Round each row before adding the results
With three amounts in A2:A4, enter =SUM(ROUNDUP(A2:A4,2)) in Microsoft 365 to add each value after rounding it up to cents. If all three cells contain 1.231, each rounds to 1.24 and the formula returns 3.72; rounding their combined total instead gives 3.70 because 1.231 × 3 is 3.693, which rounds up to 3.70. The correct order depends on the rule you are following: per-line rounding and total-only rounding are not interchangeable. This array calculation works directly in Microsoft 365; in older Excel versions, calculate each row’s rounded value in a helper column and sum that column.
How to Choose
Start by deciding what “up” means in your situation. ROUNDUP means away from zero, not always toward a larger number: positive 6.01 becomes 7, but negative -6.01 becomes -7. Use it when the requirement is explicitly to move away from zero at a fixed decimal place or place value. If you need the next multiple of a unit—five cents, 12 items, or 15 minutes—choose CEILING.MATH and supply that interval as its significance argument.
Next, identify the level at which rounding should happen. A fixed precision such as cents uses ROUNDUP with a positive digit count; tens or hundreds use a negative digit count; significant figures require a magnitude-based formula. For totals, confirm whether each line must be rounded before summation or whether only the grand total is rounded. Finally, distinguish a calculated rounded value from a display format: number formatting can show fewer decimals without changing the stored value, while ROUNDUP changes the value used in later calculations. Keep the original inputs if you need a clear audit trail, and check how negative amounts and exact multiples should behave before filling a formula down a full column.
Frequently Asked Questions
What is the ROUNDUP formula in Excel? ROUNDUP uses the syntax =ROUNDUP(number,num_digits). The first argument is the value or cell reference, and the second sets the number of decimal places or, with a negative number, the place to the left of the decimal.
What is the difference between ROUND and ROUNDUP? ROUND rounds to the nearest value at the requested precision, so the next digit affects whether it rounds up or down. ROUNDUP always increases the magnitude away from zero, regardless of the following digits.
How do I round up to the nearest 0.25? With the value in A2, use =CEILING.MATH(A2,0.25). For a positive value of 2.31, the result is 2.5, the next multiple of 0.25.
Does ROUNDUP change the number or just its appearance? ROUNDUP returns a different calculated number, which subsequent formulas use. Changing the number format only changes what is shown in the cell and leaves its stored value intact.
Why does ROUNDUP make a negative number more negative? Excel’s ROUNDUP function rounds away from zero, so -4.21 rounded to one decimal place becomes -4.3. If your rule instead requires the next multiple in the positive direction, choose a suitable CEILING.MATH setup and verify its behavior for negative inputs.
Final Thoughts
For fixed decimal or place-value rounding, ROUNDUP is the direct choice; for intervals such as pack sizes, price increments, and quarter-hours, CEILING.MATH is usually clearer. Check negative-number behavior and whether to round individual entries or the final total, then use a cell format to control how the result is displayed.
Related
- Shade Every Other Row in Excel: Quick, Reliable Methods
- Quick Way to Shade Every Other Row in Excel Automatically
- Capitalize First Letter in Excel Quickly
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel MATCH Arguments: What Each One DoesExcel’s MATCH function has three arguments: MATCH(lookup_value, lookup_array, [match_type]). The first two say what to look for and…
- Excel Sum Every Other Row: Formulas for Both PatternsIf your values are in A2:A20 and you want to add A2, A4, A6, and the rest of…
- How to Filter in Excel Without a Mouse: Keyboard GuideTo filter a list in Excel for Microsoft 365 on Windows without a mouse, select a cell in…
- Concat Excel Cell Range: Join Cells With Simple FormulasWith the values to join in A2:A5, enter =CONCAT(A2:A5) to combine the range into one text string; for…
- Excel Let Text Spill Into the Next Cell? How It WorksYes. In Excel for Microsoft 365, text can appear to spill into the cell to its right when…
- Excel TEXT Function Format Options and Examples ExplainedExcel’s TEXT function converts a number, date, or time into text displayed with a format code: use =TEXT(value,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.