Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Totals: Group totals different from Grand totals | Excel Discussion (Misc queries) | |||
how to enter totals and sub totals from receipts into excel. | New Users to Excel | |||
Summing Weekly Totals into Monthly Totals | Excel Worksheet Functions | |||
How do I sum YTD totals based on monthly totals | Excel Discussion (Misc queries) | |||
Comparing/matching totals in a column to totals in a row | Excel Worksheet Functions |