when I add values in cells which have been calculated with percen.
 

I have set up a salary schedule to calculate employee/employer percentage
deductions, social security contributions etc. and when adding, say the
employees' contributions, the total is 1 cent too little compared to doing
a manual calculation. Obvioulsy there is a rounding issue somewhere but how
can I fix it ? Any sufggestions gratefully received !

Hi
Have a look he
http://www.mcgimpsey.com/excel/pennyoff.html

--
Andy.


"David" wrote in message
...
I have set up a salary schedule to calculate employee/employer percentage
deductions, social security contributions etc. and when adding, say the
employees' contributions, the total is 1 cent too little compared to
doing
a manual calculation. Obvioulsy there is a rounding issue somewhere but
how
can I fix it ? Any sufggestions gratefully received !

"Andy B" wrote:

Hi
Have a look he
http://www.mcgimpsey.com/excel/pennyoff.html

--
Andy.


"David" wrote in message
...
I have set up a salary schedule to calculate employee/employer percentage
deductions, social security contributions etc. and when adding, say the
employees' contributions, the total is 1 cent too little compared to
doing
a manual calculation. Obvioulsy there is a rounding issue somewhere but
how
can I fix it ? Any sufggestions gratefully received !


Thanka Andy B that did the trick

Thanks for the feedback!

--
Andy.


"David" wrote in message
...


"Andy B" wrote:

Hi
Have a look he
http://www.mcgimpsey.com/excel/pennyoff.html

--
Andy.


"David" wrote in message
...
I have set up a salary schedule to calculate employee/employer
percentage
deductions, social security contributions etc. and when adding, say the
employees' contributions, the total is 1 cent too little compared to
doing
a manual calculation. Obvioulsy there is a rounding issue somewhere but
how
can I fix it ? Any sufggestions gratefully received !


Thanka Andy B that did the trick