![]() |
Adding columns
my problem is my totals on my invoice are cents off. Some totals are right to
the penny, while others are short by several cents. |
Adding columns
hi
this is a common problem in spreadsheet. it due to roundoff. check the column of numbers that you are add to see if all numbers are exactly 2 decimal places, not rounded to 2 decimal places. i'll bet that due to the numbers NOT being exactly 2 decimal places is causing you to add a half penny here and there which causes the semmingly errornous total at the botton. Regards FSt1 "Debbie" wrote: my problem is my totals on my invoice are cents off. Some totals are right to the penny, while others are short by several cents. |
All times are GMT +1. The time now is 05:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com