LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Simple math calculation - 50/50? Abi Excel Worksheet Functions 4 February 9th 05 06:11 PM
How do I use a rounded calculation result in another calculation? vnsrod2000 Excel Worksheet Functions 1 January 26th 05 10:11 PM
How do I use a rounded calculation result in another calculation? vnsrod2000 Excel Worksheet Functions 1 January 26th 05 09:36 PM
Excel Miscalculates simple formula..Help!! Dave Excel Worksheet Functions 1 January 12th 05 03:30 PM
time-clock calculation dokliver Excel Worksheet Functions 3 October 28th 04 09:07 PM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"