3 Ways for Rounding the Dollar Values in Microsoft Excel.

Posted on December 7, 2007 
Filed Under Excel Tips & Tricks

If you are working in Microsoft Excel with the Dollar function it might seem simple but there are a few things you might need to consider. I’m showing you in this Excel Tip and Trick article various ways to round up the Dollar value.

 

If you are working in an Excel Spreadsheet and you just calculated a price than the sum may be something like $116.121981537. I don’t know when the last time it was when you had $116.121981537 in your wallet? I want this value as it should be with even cents.

 

There are actually three ways to round such a value.

  • Round it up to the nearest even cent.
  • Round it down to the nearest even cent.
  • Round it to the nearest cent (up or down, which is closer by).

For this Excel Tip and Trick I’m using the dollar value $116.121981537 and for the first examples I’m placing the value only in the cell A1

 

Excel tips tricks

 

The Excel formula ROUNDS rounds the value to the nearest cent. Microsoft Excel returns for $116.121981537 the value $116.12.

=ROUND(A1,2)

The Excel formula CEILING rounds the value to the higher nearest cent. Microsoft Excel returns for $116.121981537 the value $116.13.

=CEILING(A1,0.01)

The Excel formula FLOOR rounds the value to the lower nearest cent. Microsoft Excel returns for $116.121981537 the value $116.12.

=FLOOR(A1,0.01)

Of course this is also possible for a complete row. Now you need to select the cells in row B and type in the Excel formula en press CTRL+ENTER and you’re done.

 

Excel tips tricks

 

I hope you all enjoyed this Excel Tip and Trick!

Do you want to see more? This is related...


Buzz Up Digg Mixx
Print


Comments

2 Responses to “3 Ways for Rounding the Dollar Values in Microsoft Excel.”

  1. ArahMan7 on December 8th, 2007 7:03 am

    Thanks for the tutorial. Great post, as usual.

    Frankly, I’ve never use Excel, coz I don’t how to use it. I hope by coming often, I can at least know how to use any Microsoft Office’s applications.

    Better yet, I’m subscribing your feeds. Don’t wanna miss your awesome posts.

    Greetings and lotta loves from Malaysia.

  2. Vincent on December 9th, 2007 3:36 pm

    First of all, thanks for subscribing.

    Excel is an awesome product. I couldn’t live without it anymore. It looks difficult at first but once you get the hang of it, it’s really a great product. You can really use it for anything from archiving a collection or for your administration. Just hang around and ill promise you that you’ll get the hang of it before you know it and you’ll use it quite regular.

Leave a Reply