# Rounding to Nearest Dollar in Excel: 6 Easy Ways

### Method 1 – Using ROUND Function for Rounding to Nearest Dollar

Steps:

• Select cell E5.
• Write down the following formula into the cell.

`=ROUND(D5,0)`

Here, 0 is the num_digits which helps us to round up to the decimal.

• Press Enter.

• Double-click on the Fill Handle icon to copy the formula up to cell E14.

• See all values were rounding to their nearest round dollar.

The formula worked perfectly and we are rounding the tax payment to the nearest dollar.

### Method 2 – Applying MROUND Function

Steps:

• Select cell E5.
• Write down the following formula into the cell.

`=MROUND(D5,1)`

1 is the â€˜multipleâ€™ value which helps us for rounding to the nearest dollar.

• Press the Enter key on your keyboard.

• Double-click on the Fill Handle icon to copy the formula up to cell E14.

• Get that all values were rounding to their nearest round dollar.

### Method 3 – Use of ROUNDUP Function

Steps:

• Select cell E5.
• Write down the following formula into the cell.

`=ROUNDUP(D5,0)`

0 is the num_digits that help us to round up to the decimal.

• Press the Enter key to get the result.

• Drag the Fill Handle icon with your mouse to copy the formula up to cell E14.

• Get that all values were rounding to their nearest round dollar.

### Method 4 – Utilizing CEILING Function

Steps:

• Select cell E5.
• Write down the following formula into the cell.

`=CEILING(D5,1)`

1 is the â€˜significanceâ€™ value which helps us for rounding to the nearest dollar.

• Press Enter.

• Drag the Fill Handle icon with your mouse to copy the formula up to cell E14.

• See that all values were rounding to their nearest round dollar.

### Method 5 – Rounding to Nearest Dollar Using Decrease Decimal Command

Steps:

• Select the entire range of cells D5:D14.
• Click â€˜Ctrl+Câ€™ to copy the data into the Clipboard. As a result, the original payment amount remains intact.
• Click â€˜Ctrl+Vâ€™ to paste the data in the range of cell E5:E14.

• Select the range of cells E5:E14.
• In the Home tab, click on the Decrease Decimal command locates in the Number group.

• Keep clicking on the command icon until all the digits after the decimal point will disappear.
• You will see that all values were rounding to their nearest round dollar.

• If you select any cell in the range E5:E14 and look at the Formula Bar, you can see the whole number like column D.

### Method 6 – Applying Built-in Format Cells Command

Steps:

• Select the entire range of cells D5:D14.
• Click â€˜Ctrl+Câ€™ to copy the data into the Excel Clipboard. As a result, our original payment amount will remain unchanged.
• Click â€˜Ctrl+Vâ€™ to paste the data in the range of cell E5:E14.

• Select the range of cells E5:E14.
• Right-click on your mouse and select the Format Cells option from the Context Menu.

• The Format Cells dialog box will appear.
• Select the Category as Currency or Accounting. We kept the Accounting option for better visualization of our dataset.
• In the box on the right side of the title Decimal Places, write down 0 on your keyboard. You can also keep clicking the down arrow to reduce the number until 0 appears.
• Click OK.

• You will see that all values were rounding to their nearest round dollar within a blink.

• If you select any cell in the range E5:E14 and look at the Formula Bar, you can see the original value like column D.

## Round up to Nearest 5 Dollar in Excel

Steps:

• Select cell E5.
• Write down the following formula into the cell.

`=ROUND(D5/5,0)*5`

0 is the num_digits that help us to round up to the decimal.

• Press Enter.

• Double-click on the Fill Handle icon to copy the formula up to cell E14.

• See that all values were rounding to their nearest 5 dollar.

## Related Articles

<< Go Back toÂ Rounding in ExcelÂ |Â Number FormatÂ |Â Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF