Strange Calculation Error in Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry


Hi.
I have a table of numbers, and I do some simple Math based on this data.
Eg:
4.1 4.1 3.97 4.03
4.15 4.15 4.1 4.1


For the formula "=A4-B4", the answer given is
"-0.069999999999999400000000000000"
It should be just -0.07.

Then I checked the value for A4 & B4, the values are:
4.030000000000000000000000000000
4.100000000000000000000000000000

What's wrong with Excel?
How can I correct this error?
PS: If anyone wishes to see the original Excel file, please leave your email
address here. Thanks!

--
Additional information:
- I'm using Office XP
- I'm using Windows XP

¥»¤Hªº¯à¤O«D±`¦³­­. ¦p¦³¤£·í¤§³B, ±æÃѪ̤£§[½ç¥¿!!
My ability is very limited. Hope you will not mind to enlighten me if I do
wrongly.


.

Relevant Pages

  • RayRay Game - Graph Theory?
    ... Its been a while since I've done any "real" math outside of school, ... its still in the back of mind, just further back now than it used to be ... math is behind it and how one could calculate the fewest moves needed. ... Prev by Date: ...
    (sci.math)
  • Re: When attempting to run macro Excel opens different workbook
    ... I went in and reassigned all of the macros. ... noticed that if I change the name of the original excel file I have the ... same problem in that it references the original name when trying to run ... Prev by Date: ...
    (microsoft.public.excel.programming)