Always Round Up or Down

Excel Formulas › Round

All versionsROUNDUPROUNDDOWNCEILING

Sometimes “nearest” is wrong: you need to always round up (how many boxes to order) or always down (how many whole units you can afford). ROUNDUP and ROUNDDOWN force the direction; CEILING and FLOOR do it to a multiple.

Quick formula: to always round A2 up, or up to the next multiple of 10:
=ROUNDUP(A2, 0) // up to whole number =CEILING(A2, 10) // up to next multiple of 10
ROUNDUP/ROUNDDOWN take decimal places; CEILING/FLOOR take a multiple to snap to.

Functions used (tap for the full reference guide):

ROUNDUPROUNDDOWNCEILINGFLOOR

The example

Items per box = 12. How many boxes are needed for the order quantity?

ABC
1Order qtyBoxes (÷12)Round up
2504.175
3242.002
4252.083

The formula

Boxes needed always rounds up — you can’t ship a partial box:

=ROUNDUP(A2/12, 0) // 50/12 = 4.17 → 5 boxes

How it works

The direction is guaranteed regardless of the decimal:

  1. A2/12 gives the exact number of boxes — 4.17 for 50 items.
  2. ROUNDUP(…, 0) forces it up to the next whole number, 5, because even 0.17 of a box needs a 5th box.
  3. Use ROUNDDOWN for the opposite — e.g. how many whole boxes a budget covers.
  4. CEILING(A2, 10) and FLOOR(A2, 10) do the same up/down forcing but to a multiple (next 10, previous 10).

Try it: interactive demo

Live demo

Enter a value; compare nearest, up, and down.

Variations

Round money up to the next cent

Two decimals, always up:

=ROUNDUP(A2, 2)

Round time up to the next 15 minutes

Billing in quarter-hour blocks:

=CEILING(A2, "0:15")

Always round down to a whole unit

How many whole items a budget buys:

=ROUNDDOWN(budget/price, 0)

Pitfalls & errors

ROUNDUP/ROUNDDOWN vs CEILING/FLOOR. The first pair rounds to decimal places; the second to a multiple. Pick by whether you’re snapping to digits or to a step like 5, 10, 25.

CEILING/FLOOR sign rules. In older Excel, the value and significance must share a sign or you get #NUM!. CEILING.MATH and FLOOR.MATH remove that restriction.

“Round up” isn’t “round half up.” ROUNDUP pushes everything up, even 4.01. If you want normal rounding where only .5+ goes up, use ROUND.

Practice workbook

📊
Download the free Always Round Up or Down practice workbook
The packaging example with live ROUNDUP/ROUNDDOWN/CEILING/FLOOR side by side, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I always round up in Excel?
Use =ROUNDUP(value, 0) to round up to a whole number, or =CEILING(value, multiple) to round up to the next multiple, e.g. CEILING(A2,10) for the next 10.
What's the difference between ROUNDUP and CEILING?
ROUNDUP rounds up to a number of decimal places. CEILING rounds up to the next multiple of a value you choose, such as 5, 10, or 0.25.
How do I round down to whole units?
Use =ROUNDDOWN(value, 0) or =FLOOR(value, 1). For example, ROUNDDOWN(budget/price, 0) gives how many whole items you can afford.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Round to the nearest X · Loan payment

Function references: ROUNDUP · ROUNDDOWN · CEILING · FLOOR