excel 2007 miscalculation
 

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?

excel 2007 miscalculation
 

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

http://blogs.msdn.com/excel/archive/...available.aspx

--
Biff
Microsoft Excel MVP


"Wilson" wrote in message
...
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?

excel 2007 miscalculation
 

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

"Wilson" wrote in message
...
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?

excel 2007 miscalculation
 

That problem was fixed with SP1 update.

Rob

"Wilson" wrote in message
...
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?