Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
EXCEL 2000 INCORRECTLY CALCULATES CENTS
- Thread starter Bojangle
- Start date
SimonDavis
Technical User
Can you show the formula you are using?
If the numbers are the result of another formula, is it possible that it is the formatting - if you format 99.991 and 99.998 to 2 decimals, you will get 99.99 and 100.00 respectively. It looks wrong, but if you add them up, they will still be correct.
More data please!
If the numbers are the result of another formula, is it possible that it is the formatting - if you format 99.991 and 99.998 to 2 decimals, you will get 99.99 and 100.00 respectively. It looks wrong, but if you add them up, they will still be correct.
More data please!
I agree with SimonDavis. What it sounds like is the forumla is set to round up or down. Anything before .95 would be .90 and anything after .95 would be 1.00. You can set the rounding feature in excel and you can also turn it off through your options menu.
Hope this helped
Hope this helped
- Thread starter
- #4
I think you both are right about the rounding. I went to tools, options, calculations,checked precision and the values that were rounded up example:86.71 2,678.91
84.21 2,594.71
the 2,594.71 was changed to 2.594.70.
I couldn't find any options that specifically mentioned rounding but the precision option seemed to work.
Does this sound correct to you it seemed to work.
Thank you for your help, it was greatly appreciated!
84.21 2,594.71
the 2,594.71 was changed to 2.594.70.
I couldn't find any options that specifically mentioned rounding but the precision option seemed to work.
Does this sound correct to you it seemed to work.
Thank you for your help, it was greatly appreciated!
- Status
