Round to the Nearest Half (0.5)

All versionsMROUND

Pricing in halves — $2.50, $3.00, $3.50 — means rounding to a multiple of 0.5. MROUND snaps to the nearest half, while CEILING and FLOOR force up or down.

Quick formula: round A2 to the nearest 0.5:

=MROUND(A2, 0.5)

MROUND to 0.5 lands on the closest half; use CEILING/FLOOR with 0.5 to always go up or down.

Functions used (tap for the full reference guide):

MROUND CEILING

The example

Prices snap to the nearest 50 cents.

	A	B
1	Value	Nearest 0.5
2	2.30	2.50
3	2.10	2.00

The formula

The formula:

=MROUND(A2, 0.5) // nearest half

How it works

How it works:

MROUND(value, 0.5) rounds to the nearest half — 2.30 to 2.50, 2.10 to 2.00.
CEILING(value, 0.5) always rounds up to the next half; FLOOR always down.
Swap 0.5 for 0.25 (quarters) or 0.1 (dimes) to round to other fractions.
For half-up pricing psychology, combine with a subtraction: =CEILING(A2,0.5)-0.01 gives .49 / .99 style endings.

Halves and quarters everywhere: the same pattern handles time (round to the nearest quarter-hour with MROUND(time, "0:15")), grades (nearest half-point), and ratings. MROUND is the general “snap to a step” tool.

Try it: interactive demo

Live demo

Value and step.

Value

Step

Nearest · Up · Down

Variations

Always up

Next half:

=CEILING(A2, 0.5)

Nearest quarter

0.25 step:

=MROUND(A2, 0.25)

Nearest quarter-hour

Time:

=MROUND(A2, "0:15")

Pitfalls & errors

MROUND ties round up. A value exactly on the half-step (2.25 to nearest 0.5) rounds away from zero.

Sign must match. In older Excel, MROUND errors if value and multiple have different signs.

Pick the step. 0.5 = halves, 0.25 = quarters, 0.1 = dimes — change the multiple, not the function.

Practice workbook

📊

Download the free Round to the Nearest Half (0.5) practice workbook

A nearest-half sheet with the round-up, quarter, and quarter-hour variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I round to the nearest 0.5 in Excel?

Use =MROUND(value, 0.5). For quarters use 0.25, for dimes 0.1. CEILING/FLOOR with 0.5 force rounding up or down.

How do I always round a price up to the next half?

Use =CEILING(value, 0.5), which rounds up to the next multiple of 0.5.

Can I round time to the nearest quarter-hour?

Yes: =MROUND(time, "0:15") snaps a time value to the nearest 15 minutes.

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

Function references: MROUND · CEILING