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