View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Hello, Some of my cell totals are off by one penny!

Hi Lori,

Am Thu, 7 Apr 2016 11:14:39 -0700 (PDT) schrieb :

In case the screenshots don't work, these are the figures in one example:
3/4/16 $108.04
3/5/16 $107.57
3/18/16 $107.57
3/25/16 $107.34 These figures are part of a formula that takes them from each of the employees Payroll deduction on different sheets in same spreadsheet.

March Total $430.51 (SHOULD BE $430.52) This # is a simple sum of the above 4 cells.


please have a look:
https://support.microsoft.com/de-de/kb/78113
Use ROUND instead format for the cells with the formulas.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional