On Wed, 21 May 2008 22:00:01 -0700, tjatja
wrote:

there are bugs in microsoft exel 2007 for calculation of:
154,2 x 1700 = 262.140 if the result we divide by 4 equal to 100.000 and
then if we multiply again with 4 it's back to 262.140
and also if the result (262.140) we divide by 2 and than multiply again with
2 the result is 100.000
or:
154,2 x 1700 = 262.140 / 4 = 100.000 x 4 = 262.140 /2 = 131.070 / 2 = 100.000

any comment? or do i have to use previous microsoft exel to avoid this bug?


I cannot reproduce your problem.

When I enter: =154.2*1700/4

I get 65535


Excel 2007 SP1 (US edition)
--ron