ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding columns (https://www.excelbanter.com/excel-discussion-misc-queries/200064-adding-columns.html)

Debbie

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.

FSt1

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