Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In my payroll spreadsheet used to track deductions and PR taxes due I found some (not all) totals are off by a penny. This is so weird. I don't have any rounding selected & I have decimal selected at 2 places (normal currency).
1) Link to my screenshot: /Users/sandyryan/Desktop/Screen Shot 2016-04-07 at 1.46.23 PM.png 2) Pasted Screenshot he https://mail.google.com/mail/u/0/?ui...6d&zw&atsh =1 I've attempted to add a screenshot but I'm not sure if either of them will work (there are 2 different attempts at adding it here). 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. Quarter 1 Total $1,283.63 (off by 2 cents as the same thing happened in my February column, however the January column is correct.) Ugh! I would very much appreciate any help I might receive!! Thank you! Lori Thompson 239-810-0421 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calc sometimes off by a penny | Excel Worksheet Functions | |||
Exel 2007 penny off | Excel Discussion (Misc queries) | |||
Adding Incorrectly - off by 1 penny | Excel Discussion (Misc queries) | |||
My accounting program is a penny off, Why? | Excel Worksheet Functions | |||
Test for fractions of a penny | Excel Programming |