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 three functions below and a few ways to use them. They all call for the same two arguments: number (your original decimal value) and num_digits (the number of digits you want after the decimal place). Input 0 for num_digits to round to the nearest dollar.
In this Article
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
“Charm pricing” is a sales tactic where the price is set just below a round number by using 99¢. It seems lower than the next whole number without having to sacrifice much profit.
By subtracting .01 from any of the above formulas, we can round a price to end in .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.