Thread
:
Hello, Some of my cell totals are off by one penny!
View Single Post
#
2
Posted to microsoft.public.excel.misc
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch