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

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on December 13, 2023
Download Example Workbook

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 no decimal

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.

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).



ROUNDUP Function

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 Function


Round Nearest Cent

ROUNDUP Function


Roundup Nearest Cent



Rounddown 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.


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 gs no decimal


  • You can change number formatting if you want to keep the original decimal value but display as a round number.
  • Use Paste Special if you want to replace the original values with the rounded prices and save them as values.

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List