Microsoft Excel 2003 calculation problem.?
I'm an accountant and I use Excel spreadsheest quite a bit to reconcile accounts. I have a colum of number then to get the sum I put in the formula =Sum(and the colums in here) and it giving me a total thats 1- 2 cents off (not each time but ever 10 or so documents). My co worker and fellow accountant experiencing the same problem on her computer. The program is on our individual computer so what is the problem and is there a patch to fix it?
I'm only using dollars and cents for example 1.25 in one colum and 1.20 in another (but using around 50 colums) and it wil sum it up to 1.46 on stead of the obvious in this case 1.45
- tercir2006Lv 71 decade agoFavorite Answer
I give Jim Ponder a thumbs up. He may be on the right track. That was my though as well. However, I think the problem you are describing may be something else.
Can you make a copy and e-mail it to me so I can see what is going on? Make sure you delete all ACTUAL information and just make fictitious stuff. All I want is to see how the program is performing. There may be an alternative answer to your problem or approach.
I've worked with Excel since 1984, so I've learned a thing or two about it.
If you have IM installed, log in and contact me. We can discuss more details about what you are doing. Remember, I have lots of experience with Excel, and know many of the little things everybody else seems to have missed.
Anyway, it's up to you.
- Barkley HoundLv 71 decade ago
The individual numbers you are adding are probably being displayed as rounded. The total sums the entire stored number, not the displayed one. I have seen results of 12/3 that result in 4.00000001. To be safe round off the numbers.
I assume each number you are adding is the result of a calculation. Add the round function to each result to drop the extra digits.
- devilishblueyesLv 71 decade ago
It could be do to how you or Excel is rounding. If you are using some of the financial functions in Excel, some of them may be off by a little bit. So you might want to take that into account also.
You might also want to see if there are any hidden rows or columns you might be missing or do a formula audit by going to Tools > Formula Auditing
You might also want to utilize the formulas such as:
- Anonymous1 decade ago
In excel when you use formula, the integer in fraction gets rounded off to full number. for example the number 1.45 is rounded as 1.00 and the number 1.55 is rounded as 2.00. so while using the formula the difference always comes from 1 to 2 numbers when you are using formula for different rows. The ideal way is to adjust the values to nearest whole number manually so that balance should tally with that of individual formula values.
- How do you think about the answers? You can sign in to vote the answer.
- Anonymous5 years ago
The best way to get the formula to not show up until something is entered into column "B" is to utilize an IF statement =if(B2="","",30-(TODAY()-B2)) This basically says if B2 is blank, then display blank otherwise if there is data in B2, run the formula Hope this helps
- 1 decade ago
Scroll down and select all your numerical cells or your selected cells from your worksheets
got to CELLS
in the NUMBER tab select ACCOUNTING
leave the DECIMAL PLACES at 2
I suggest that everyone in your office do the same. Your records will then match.
- jimponderLv 51 decade ago
Have you expanded your decimal places to say .0000? This might be where your problem is. Make sure you are on service pack 2 or greater.Source(s): IT Pro.