Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple math calculation - 50/50? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions | |||
time-clock calculation | Excel Worksheet Functions |