Thread: Adding columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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.