View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default My Excel totals are always 1 or 2 cents too low. Any ideas?

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Andyb" wrote in message ...
| Using Excel 2003, front worksheet has a column with a total at the bottom.
| Cells that are being added in that column are derived from other worksheets
| within the same workbook. My total at the bottom of the column is always 1
| or 2 cents too low. I'm suspecting the figures were rounded up somewhere
| alon the line and now the final figure is not rounding up. Any help would be
| greatly appreciated.
|
| Andyb