calculate error

[StarMild]

In Excel 2007, try this case:

A1 154.2
A2 1700
A3 A1*A2 (the answer is 262140)
A4 4
A5 A3/A4 (the answer is 100000, this is a wrong answer)

compare the case using calculator

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...758450c&dg=microsoft.public.excel.crashesgpfs

 

[Jerry W. Lewis]

MS published a patch for this half a year ago
http://support.microsoft.com/kb/943075

For more info about the underlying cause, se
http://groups.google.com/group/microsoft.public.excel.misc/msg/830e88a3f4dddf9b

You would have gotten a much faster rewsponse had you posted in a more
appropriate discussion group. The topic of this group is things that cause
Excel to crash. Since Excel rarely crashes, this group is not widely read.

Jerry