Adding columns

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum totals - Help 1
Say it in words 2
excel 2
Autosum Calculating Wrong 5
Help with Formula 2
Formulas with no results 3
incorrect calculations 3
Help with calculation 1

Back
Top