Hello,

I encountered rounding issue in excel and I can't find any solution to this problem on any website. Perhaps I'm doing something wrong?

I have a set of data that I multiply by a percantage and then do the rounding to 2 decimal points. This changes the total of the data but I want to keep the total the same!

Eg.

Total to be paid to customers: 12021.30

Service x to get 0.46% * 12021.30
Service y to get 0.09% * 12021.30
Service z to get 0.37% * 12021.30

and so on...

The data needs to be rounded to 2 decimal points in order to be able to be uploaded into the financial system and the total of all the 'service' entries needs to match the payment amount which is 12021.30. Each time I use the =round,2 formula the total is off by a few cents.

What is the best solution to this problem?