Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding from several columns if ... | Excel Worksheet Functions | |||
Adding Columns | Excel Discussion (Misc queries) | |||
Adding columns | Excel Discussion (Misc queries) | |||
Adding Columns | Excel Discussion (Misc queries) | |||
adding columns | Excel Discussion (Misc queries) |