View Single Post
  #1   Report Post  
Tobias
 
Posts: n/a
Default error in simple calculation?

Hello everybody

I have a small problem...

I have entered 2.5% in A1, 100% in A2 ans 100 in A3.

In A4 I have the following formula: =A3*(1+$A$1)-(A3*$A$1) with the
result 100.
(In fact I calculate an interest on a certain amount and just after I
withdraw the interest)

Now I copy this formular in the next 20 cells beneath A4 and I recieve
the following results:

A5: 100
A6: 100
A7: 99.999999999999900 ????
A8: 99.999999999999900
A9: 99.999999999999900
A10: 99.999999999999900
A11: 99.999999999999900
A12: 99.999999999999900
A13: 99.999999999999900
A14: 99.999999999999800 ????
A15: 99.999999999999800
A16: 99.999999999999800
A17: 99.999999999999800
A18: 99.999999999999800
A19: 99.999999999999800
A20: 99.999999999999800
A21: 99.999999999999700 ????
A20: 99.999999999999700

and so on (this value remains).

Shouldn't the result of this calculation always be exactly "100"?

What do I do wrong? Thank you very much for any help.

best regards, Tobias