excel 2007 miscalculation

[Wilson]

try this:
A1 = 154.2
B1 = 1700
C1 = A1*B1 give answer 262140 (correct)
D1 = 4
E1 = C1/D1 give answer 100000 (incorrect, the answer must be 65535)

does anyone know this error?

 

[T. Valko]

If you run Office Update that should get fixed. Here's a link to the fix:

http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.aspx

 

[Tyro]

Is is not a miscalculation. The display of the number is wrong. MS has
corrected this, but I cannot remember where the patch is.

Tyro

 

[RobN]

That problem was fixed with SP1 update.

Rob