Round Price to Nearest Dollar or Cent in Excel & Google Sheets
Download the example workbook
This tutorial will demonstrate how to round a price to the nearest dollar or cent in Excel and Google Sheets.
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 all work the same way; Input num_digits = 0 input to round to the nearest dollar.
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).
The ROUNDUP Function will round up to the nearest dollar.
The ROUNDDOWN Function will round down to the nearest dollar.
Round Price to Nearest Cent
By setting the num_digits input to 2 we can round to the 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.
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.