# How to round prices to end in .99 in Excel

Round up to the next whole number and take off a cent: `=ROUNDUP(B2,0)-0.01`.

**Excel:** `=ROUNDUP(B2,0)-0.01` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C |
| --- | --- | --- |
| Product | Calculated price | Shelf price |
| Desk lamp | 23.4 |  |
| Notebook set | 8.15 |  |
| Water bottle | 17.99 |  |
| Backpack | 42 |  |
| Headphones | 61.72 |  |

Formula in C2, filled to C6: `=ROUNDUP(B2,0)-0.01`

Result: $23.99; $8.99; $17.99; $41.99; $61.99

## How it works

ROUNDUP with 0 digits moves 23.40 up to 24, and subtracting 0.01 gives 23.99. A price that already ends in .99 stays the same. A whole-dollar price like 42.00 is already "rounded up", so it becomes 41.99, a cent below the calculated price.

## Other ways

- `=INT(B2)+0.99`: Keeps the dollars and sets the cents to .99, so a whole-dollar price goes up instead. (The 42.00 backpack becomes 42.99.)

## Common mistakes

- Decide what happens to whole-dollar prices: ROUNDUP gives 41.99 (below the calculated 42.00), INT(B2)+0.99 gives 42.99. Pick the rule that protects your margin.
- Rounding a price that is already a few cents above .99 (like 24.02) adds almost a dollar. Check the effect on the cheapest items.

## Questions

**How do I make prices end in .95?**

Use `=ROUNDUP(B2+0.05,0)-0.05`, which gives the next price ending in .95 at or above the calculated one.

**How do I round to the nearest .99 instead of up?**

Use `=ROUND(B2,0)-0.01`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/round-prices-to-99