Rounding error correction fix

[Dtech69]

I have a cell where I can enter a $ value.
The cells above that each hold a variable % that, when totaled equal 100%
I add the $ value in a cell & the percentages in another then it fills in the $ percentage above.
Since this is in $ it rounds out 2 decimals.
Sometimes it rounds so the totals no longer equal out and is off by $.01.

How can I get to compare the sum to the originally entered total so it rounds one of the cells down so they will add correctly?

This is hard to explain & I can send the sheet I made if I could.

Thanks,
David

[Pete_UK]

Yes, it is probably better to attach a sample Excel file, then we can see which cells are affected.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon does not work.

Pete

[Dtech69]

Thank you.
I added it here, I hope this works.

[davsth]

You firstly create your values as rounded and not just formatted to the correct figure eg c2 is:
=ROUND($C$10*A2,2)

then you have to decide which cell you will change to make the figures match c8 could be c10 -sum(c2:c7) and it would balance

or you adjust the maximum value, although if you have more than one maximum, this could be more problematic