Often you may want to round prices in Excel to the nearest dollar.
You can use the following methods to do so:
Method 1: Round to Nearest Dollar and Display Cents (e.g. $22.00)
=ROUND(B2, 0)
Method 2: Round to Nearest Dollar and Do Not Display Cents (e.g. $22)
="$"&INT(ROUND(B2,0))
Both methods assume that the price you’re rounding is in cell B2.
The following examples show how to use each method in practice with the following dataset in Excel:
Example 1: Round to Nearest Dollar and Display Cents
We can type the following formula into cell C2 to round the price in cell B2 to the nearest dollar:
=ROUND(B2, 0)
We can then click and drag this formula down to each remaining cell in column C;
Column C displays each of the prices in column B rounded to the nearest dollar.
Example 2: Round to Nearest Dollar and Do Not Display Cents
We can type the following formula into cell C2 to round the price in cell B2 to the nearest dollar and avoid displaying the cents:
="$"&INT(ROUND(B2,0))
We can then click and drag this formula down to each remaining cell in column C:
Column C displays each of the prices in column B rounded to the nearest dollar and does not display the cents.
Note that this method uses the & symbol to concatenate a dollar sign with only the integer portion of the rounded dollar value.
The end result is that the price is rounded to the nearest dollar and the cents is not shown.
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Excel: How to Use MROUND to Always Round Down
Excel: How to Use MROUND to Always Round Up
Excel: How to Round to Significant Figures
