Rounding to Nearest Dollar in Excel (6 Easy Ways)

Rounding to the nearest dollar of any price list or any payment list is a pretty common task in our regular life. It provides us with more flexibility in the cash payment system. In this context, we will demonstrate to you 6 different methods of rounding to the nearest dollar in Excel. If you are interested to know about it, download our practice workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


6 Easy Ways for Rounding to Nearest Dollar in Excel

To demonstrate the approaches, we consider a dataset of 10 employees of an institution. The name of the employees are in column B, their salaries per month and the tax payment are in columns C and D respectively. Our dataset is in the range of cells B5:D14. We will be rounding the tax payment to the nearest dollar for the convenience of cash payment, and the final rounded amount will show in column E.


1. Using ROUND Function for Rounding to Nearest Dollar

In this method, we are going to use the ROUND function for rounding to the nearest dollar in Excel. The final result will be in column E. The steps of this method are given below:

📌 Steps:

  • First of all, select cell E5.
  • Now, 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.

  • Then, press the Enter key.

Using ROUND Function for Rounding to Nearest Dollar

  • After that, double-click on the Fill Handle icon to copy the formula up to cell E14.

  • You will see all values were rounding to their nearest round dollar.

Using ROUND Function for Rounding to Nearest Dollar

Thus, we can say that our formula worked perfectly and we are rounding the tax payment to the nearest dollar.

Read More: How to Round to Nearest 10 Cents in Excel (4 Suitable Methods)


2. Applying MROUND Function

In this following approach, we will use the MROUND function for rounding to the nearest dollar in Excel. Our dataset is in the ranges of cells B5:D14 and the final result will be in column E. The steps of this process are given below:

📌 Steps:

  • First, select cell E5.
  • Then, write down the following formula into the cell.

=MROUND(D5,1)

Here, 1 is the ‘multiple’ value which helps us for rounding to the nearest dollar.

  • After that, press the Enter key on your keyboard.

Applying MROUND Function for Rounding to Nearest Dollar

  • Now, double-click on the Fill Handle icon to copy the formula up to cell E14.

  • You will get that all values were rounding to their nearest round dollar.

Applying MROUND Function for Rounding to Nearest Dollar

Finally, we can that our formula worked successfully and we are rounding the tax payment to the nearest dollar.

Read More: Round Time to Nearest 5 Minutes in Excel (4 Quick Methods)


3. Use of ROUNDUP Function

In this process, we will apply the ROUNDUP function for rounding to the nearest dollar in Excel. Our dataset is in the ranges of cells B5:D14 and the final result will be in column E. The procedure of this process is given as follows:

📌 Steps:

  • At the beginning of this process, select cell E5.
  • Then, write down the following formula into the cell.

=ROUNDUP(D5,0)

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

  • Press the Enter key to get the result.

Use of ROUNDUP Function for Rounding to Nearest Dollar

  • Now, drag the Fill Handle icon with your mouse to copy the formula up to cell E14.

  • Finally, You will get that all values were rounding to their nearest round dollar.

Use of ROUNDUP Function for Rounding to Nearest Dollar

So, we can that our formula worked precisely and we are rounding the tax payment to the nearest dollar.

Read More: How to Roundup a Formula Result in Excel (4 Easy Methods)


Similar Readings


4. Utilizing CEILING Function

In this procedure, the CEILING function will help for rounding to the nearest dollar in Excel. We will show the final result in column E. The approach is explained below:

📌 Steps:

  • To start up, select cell E5.
  • After that, write down the following formula into the cell.

=CEILING(D5,1)

Here, 1 is the ‘significance’ value which helps us for rounding to the nearest dollar.

  • Press the Enter key.

Utilizing CEILING Function for Rounding to Nearest Dollar

  • Then, drag the Fill Handle icon with your mouse to copy the formula up to cell E14.

  • In the end, You will see that all values were rounding to their nearest round dollar.

Utilizing CEILING Function for Rounding to Nearest Dollar

At last, we can that our formula worked effectively and we are rounding the tax payment to the nearest dollar.

Read More: How to Remove Decimals in Excel with Rounding (10 Easy Methods)


5. Rounding to Nearest Dollar Using Decrease Decimal Command

In the following method, we are going to use the Decrease Decimal command for rounding to the nearest dollar in Excel. We will show the final result in column E, and our dataset is kept in the range of cells B5:D14. The procedure is described below step by step:

📌 Steps:

  • First, select the entire range of cells D5:D14.
  • Now, click ‘Ctrl+C’ to copy the data into the Clipboard. As a result, the original payment amount remains intact.
  • Then, click ‘Ctrl+V’ to paste the data in the range of cell E5:E14.

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

Rounding to Nearest Dollar Using Decrease Decimal Command

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

Rounding to Nearest Dollar Using Decrease Decimal Command

  • However, 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.

Rounding to Nearest Dollar Using Decrease Decimal Command

In the end, we can that our rounding method worked perfectly and we were rounding the tax payment to the nearest dollar.

Read More: Excel VBA: Round to Nearest 5 (Macro and UDF)


6. Applying Built-in Format Cells Command

In this case, we are going to use the Excel built-in Format Cells command for rounding to the nearest dollar in Excel. Our dataset is kept in the range of cells B5:D14, and we will show the final result in column E. The steps of this approach are given as follows:

📌 Steps:

  • First of all, select the entire range of cells D5:D14.
  • Then, click ‘Ctrl+C’ to copy the data into the Excel Clipboard. As a result, our original payment amount will remain unchanged.
  • After that, click ‘Ctrl+V’ to paste the data in the range of cell E5:E14.

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

Applying Built-in Format Cells Option for Rounding to Nearest Dollar

  • As a result, the Format Cells dialog box will appear.
  • Then, select the Category as Currency or Accounting. In our case, 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.
  • Finally, click OK.

Applying Built-in Format Cells Option for Rounding to Nearest Dollar

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

Applying Built-in Format Cells Option for Rounding to Nearest Dollar

  • However, 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.

Applying Built-in Format Cells Option for Rounding to Nearest Dollar

Thus, we can that our rounding method worked successfully and we were rounding the tax payment to the nearest dollar.

Read More: How to Stop Excel from Rounding Large Numbers (3 Easy Methods)


Round up to Nearest 5 Dollar in Excel

According to this process, we will round up the tax payment value to the nearest 5 dollar. This type of rounding is often used in business to provide a consumer with some reduction facility on the payment. We will use the same dataset that we used in our previous method. You have to modify it for your dataset. We will use the ROUND function to get the value. The process is explained below:

📌 Steps:

  • At first, select cell E5.
  • Now, write down the following formula into the cell.

=ROUND(D5/5,0)*5

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

  • Press the Enter key.

Round up to Nearest 5 Dollar in Excel

  • Then, double-click on the Fill Handle icon to copy the formula up to cell E14.

  • In the end, you will see that all values were rounding to their nearest 5 dollar.

Round up to Nearest 5 Dollar in Excel

Finally, we can that our formula worked effectively and we are rounding the tax payment to the nearest dollar.

Read More: Round off Formula in Excel Invoice (9 Quick Methods)


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you can perform the rounding to the nearest dollar in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo