# Rounding issue

#### daanderson

##### New Member
Hi, I have been struggling with a problem and hoping someone can help me. I have an extensive workbook with numerous formulas, pivot tables, etc. One thing feeds off another and so on. I have had a number of issues with it and have always been able to get help here, so here goes...

My current problem is rounding. A lot of my calculations take an hour amount times a rate. This information is "sucked out" as values and forwarded to another agency. When they pull this information into their database, we are coming up with 1 cent and 2 cent variances - which is a show stopper and needs to be redone. I have tried changing to "precision as displayed", turning "precision as displayed" off (seems to get a little more accurate actually - but not enough).

Is there anything I can include in a formula to make this stop? To stop at the 2 decimal places and do not include anything past that?

I am on my fifth submission of this report for pennies!

Thanks a bunch for any help!

### Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

#### Andrew Poulsom

##### MrExcel MVP
Have you tried using the ROUND function in your formulas, eg?

=ROUND(YourFormula,2)

#### Gerald Higgins

##### Well-known Member
Have you tried rounding formulas ?

Roundup - 3.2 becomes 4
Rounddown - 3.8 becomes 3
Round - 3.2 becomes 3 and 3.8 becomes 4.

You need to decide yourself which one suits your application, but once you've decided, this should help you.

#### Gerald Higgins

##### Well-known Member
Sorry I was oversimplifying.

As Andrew Poulsom alluded to, you have more detailed options.

For example, round(1.234,0) will return 1.
But round (1.234,2) will return 1.23 and so on.

#### daanderson

##### New Member
Thanks! This should do it!

#### Scott Huish

##### MrExcel MVP
Also note that if you use ROUNDUP and ROUNDDOWN, negative numbers will do the opposite. There are ways around this, it just depends on what you need.

With =ROUNDUP(A1,0) for example:
3.8 becomes 4
-3.8 becomes -4

Replies
0
Views
180
Replies
4
Views
169
Replies
7
Views
305
Replies
4
Views
271
Replies
2
Views
382

1,191,031
Messages
5,984,235
Members
439,879
Latest member
KingGoulash

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back