Excel Round Up to Dollar: 4 Easy Ways

Formulas & functions · Updated November 22, 2026

To round a number up to the nearest whole dollar in Excel, use the ROUNDUP function with 0 decimal places: =ROUNDUP(A1,0). For example, if A1 contains 12.34, the formula returns 13. This always rounds away from zero, so negative numbers like -12.34 become -13. If you need to round up to the nearest dollar but keep cents as a whole number (e.g., 12.34 → 13), this is the simplest method. For more control—like rounding up to the nearest $5 or $10—use CEILING or MROUND as described below.

Why Round Up to the Dollar?

Rounding up to a whole dollar is common in financial reports, invoices, and inventory pricing. Businesses often round up to avoid dealing with pennies in cash transactions, or to simplify estimates. Excel’s built-in rounding functions give you precise control, but the choice of function depends on whether you want to round up always, round to the nearest, or round to a specific multiple.

The ROUNDUP Function: Always Round Up

The ROUNDUP function rounds a number away from zero to a specified number of digits. To round to the nearest whole dollar, set the second argument to 0:

=ROUNDUP(A1,0)

Assume A1 contains 12.01. The result is 13. If A1 contains 12.99, the result is 13. If A1 contains -12.01, the result is -13 (because it rounds away from zero). To round up to the nearest hundred dollars, use =ROUNDUP(A1,-2), which turns 1234 into 1300.

The CEILING Function: Round Up to a Multiple

If you need to round up to the nearest dollar, but also want to round up to a specific multiple (like $5 or $10), use CEILING. The syntax is =CEILING(number, significance). For example, to round up to the nearest dollar, use =CEILING(A1,1). To round up to the nearest $5, use =CEILING(A1,5). If A1 is 12.34, =CEILING(A1,5) returns 15. For negative numbers, CEILING rounds toward zero (e.g., -12.34 with significance 1 becomes -12), which differs from ROUNDUP. If you need to always round away from zero, combine with ABS or use ROUNDUP.

Using MROUND for Nearest Dollar (Not Up)

Sometimes people confuse “round up” with “round to nearest.” If you want to round to the nearest dollar (not always up), use =ROUND(A1,0) or =MROUND(A1,1). The ROUND function rounds half away from zero: 12.5 becomes 13, but 12.4 becomes 12. MROUND rounds to the nearest multiple of the second argument; =MROUND(A1,1) gives the same result as =ROUND(A1,0) for positive numbers. For negative numbers, MROUND rounds toward zero, while ROUND rounds away from zero for halves. Choose based on your rounding convention.

How to Apply Rounding to an Entire Column

To round up all values in a column, enter the formula in a new column and drag down. For example, with values in A2:A100, put =ROUNDUP(A2,0) in B2 and double-click the fill handle. If you want to replace the original values, copy the formula results and paste as values (Ctrl+C, then Ctrl+Alt+V, then V for values). On a Mac, use Command+C and then Command+Control+V. Alternatively, use Excel’s built-in number format to display as whole dollars without changing the underlying value: select the cells, press Ctrl+1 (or Command+1 on Mac), go to Number tab, choose Currency or Number, and set Decimal places to 0. Note that this only changes the display, not the actual number.

Common Problems and Misconceptions

One common mistake is using =ROUND(A1,0) when you want to always round up—this rounds down for values below .5. Another is using =CEILING(A1,1) with negative numbers and expecting it to round away from zero; it doesn’t. Also, the INT function rounds down to the nearest integer, not up. For example, =INT(12.99) returns 12, which is not what you want. If you need to round up to the nearest dollar but also handle negative numbers consistently, use =IF(A1>0, CEILING(A1,1), ROUNDUP(A1,0)).

Frequently Asked Questions

How do I round up to the nearest dollar in Excel?

Use =ROUNDUP(A1,0) to always round up to the nearest whole dollar. For example, 12.01 becomes 13. This works for negative numbers too, rounding away from zero.

What is the difference between ROUNDUP and CEILING?

ROUNDUP rounds away from zero to a specified number of digits. CEILING rounds up to a multiple of a given significance. For positive numbers, =ROUNDUP(A1,0) and =CEILING(A1,1) give the same result. For negative numbers, ROUNDUP rounds away from zero (e.g., -12.01 becomes -13), while CEILING rounds toward zero (e.g., -12.01 becomes -12).

Can I round up to the nearest $5 or $10?

Yes, use =CEILING(A1,5) for the nearest $5 or =CEILING(A1,10) for the nearest $10. For example, 12.34 with CEILING(A1,5) returns 15.

Does formatting as a whole dollar change the value?

No. Changing the number format to show zero decimal places only affects the display. The underlying value remains unchanged. To permanently round the value, use a formula and paste as values.

What if I want to round up to the nearest dollar but keep cents as a whole number?

That phrasing is ambiguous. If you mean round up to the next whole dollar (e.g., 12.34 → 13), use ROUNDUP. If you mean round the cents to the nearest dollar (e.g., 12.50 → 13), use ROUND(A1,0).

Alternatives and Advanced Tips

For more complex scenarios, you can combine functions. For example, to round up to the nearest dollar and then add a tax, use =ROUNDUP(A1*1.08,0). To round up to the nearest dollar but only if the value is above a threshold, use an IF statement. If you’re using Excel for Mac, the functions work the same, but keyboard shortcuts differ: use Command+C for copy, Command+V for paste, and Command+1 for Format Cells. In Excel for the web, ROUNDUP and CEILING are available, but the ribbon paths differ slightly—look under the Home tab for Number formatting. Remember that ROUNDUP and CEILING are volatile-free and recalculate automatically when source cells change.

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.