Round Price to Nearest Dollar or Cent in Excel & Google Sheets

This tutorial will demonstrate how to round a price to the nearest dollar or cent in Excel and Google Sheets.

Round Price Formula Main

Round Price to Nearest Dollar

There are several rounding functions that you can use to round prices. We will walk through each function below, but they will all take the same num_digits = 0 input to round to the nearest dollar.

ROUND Function

The ROUND Function can round a currency value to the nearest dollar using standard rounding rules (anything below $0.50 rounds down, otherwise rounds up).

ROUND

ROUNDUP Function

The ROUNDUP Function will round up to the nearest dollar.

ROUNDUP

ROUNDDOWN Function

The ROUNDDOWN Function will round down to the nearest dollar.

ROUNDDOWN

Round Price to Nearest Cent

By setting the num_digits input to 2 we can round to the nearest cent.

ROUND Function

Round Nearest Cent

ROUNDUP Function

Roundup Nearest Cent

ROUNDDOWN Function

Rounddown Nearest Cent

Round Price to end in 99

By subtracting .01 from any of the above formulas, we can round a price to end in 99 cents.

Nearest 0.99

 

Round Price to Nearest Dollar or Cent in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Round Price Formula Google