Sum totals - Help
 

When I use the sum total to total columns to do payroll it keeps calculating
it but is off by either 1 cent or up to 5 cents. When I re-calculate on my
calculator to double check for accuracy it is higher.

I set the format to 2 decimal places but sums using 3 or even 4 decimal
places then it rounds up which is throwing of the totals by cents.

I need it to be to the penny, could use some help.
--
Rdrake

Sum totals - Help
 

Have a look here

http://www.mcgimpsey.com/excel/pennyoff.html

Mike

"Rdrake" wrote:

When I use the sum total to total columns to do payroll it keeps calculating
it but is off by either 1 cent or up to 5 cents. When I re-calculate on my
calculator to double check for accuracy it is higher.

I set the format to 2 decimal places but sums using 3 or even 4 decimal
places then it rounds up which is throwing of the totals by cents.

I need it to be to the penny, could use some help.
--
Rdrake