bugs in microsoft exel 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tjatja - 22 May 2008 06:00 GMT

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?

Reply to this Message

jlclyde - 22 May 2008 07:34 GMT

> 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
[quoted text clipped - 5 lines]
>
> any comment? or do i have to use previous microsoft exel to avoid this bug?

Excel follows the rules of math which are it will do all steps inside
parenthases then it will do all multiplting then dividing then adding
then subtracting. Chek to make sure that the result that you want to
come up with is not breaking these rules.
Jay

Reply to this Message

tjatja - 22 May 2008 08:14 GMT

> > 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
[quoted text clipped - 11 lines]
> come up with is not breaking these rules.
> Jay

I know the rules, but if you follow the step that i made by exel and you
check 262.140 divide by 4 the result is not 100.000 but it should be 65.535
please check with your calculator not using your exel
it's mean exel is calculated it wrong.

compare the result with calculator
154,2 x 1700 / 4 =
the result by exel will be 100.00
and with calculator will be 65.535

and 262.140 / 4 = 65.535 not 100.000

Imagine if it used by engineer what will it be.

Reply to this Message

David Biddulph - 22 May 2008 09:08 GMT

This was discussed at length when the problem was discovered last year.
You'll find numerous mentions on this and other Excel newsgroups. For a
more recent reference, try http://preview.tinyurl.com/6cmunr

Signature

David Biddulph

> 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
[quoted text clipped - 8 lines]
> any comment? or do i have to use previous microsoft exel to avoid this
> bug?

Reply to this Message

tjatja - 26 May 2008 09:05 GMT

Thanks David,
after upgrading my office to sp1, it's solve the problem

regards

> This was discussed at length when the problem was discovered last year.
> You'll find numerous mentions on this and other Excel newsgroups. For a
[quoted text clipped - 11 lines]
> > any comment? or do i have to use previous microsoft exel to avoid this
> > bug?

Reply to this Message

Ron Rosenfeld - 22 May 2008 12:21 GMT

>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
[quoted text clipped - 5 lines]
>
>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

Reply to this Message

Ron Rosenfeld - 22 May 2008 12:22 GMT

>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
[quoted text clipped - 5 lines]
>
>any comment? or do i have to use previous microsoft exel to avoid this bug?

No, you just need to update to SP1.

Probably you have not updated to SP1 This problem was reported, and fixed by
Microsoft, some time ago. It is a problem with the display engine within
Excel, supposedly.
--ron

Reply to this Message