View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rdrake Rdrake is offline
external usenet poster
 
Posts: 1
Default 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