Return to Excel Formulas List

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

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.

mf round price

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.

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

Easy Excel Automation

Add Excel automation to your workbook with just a few clicks.

Learn More

ROUNDUP Function


Roundup Nearest Cent



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

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