Bits und andere Biester

Ist echt interessant. Werde ich das nächste mal in der Firma glatt mal ausprobieren. Die haben da das 07er-Office-Paket:

Simply when you try to multiply 850 by 77.1 excel display the result to be
100000 !!!

———

Wow! How did you find this major bug?
Even Sumproduct returned 100000.

=SUMPRODUCT(850,77.1)
=SUMPRODUCT(850,77.1,2,0.5)
(2*0.5 = 1)
This seems Major to me!

———

There appears to be more of them. For example:

=5.1*12850
=10.2*6425
=20.4*3212.5
=40.8*1606.25
=77.1*850
=154.2*425
=212.5*308.4
=308.4*212.5
=425*154.2
..etc

What’s even stranger is this: Suppose the formula is in A1.
=A1+1 returns 100001, which appears to show the formula is in fact 100000
and a very Serious problem.
And if you multiply be say, 2 you get something else:
=A1*2
returns 131070, as if A1 had 65535. (which it should have been)
=A1*1
Keeps it at 100000.
=A1-1 returns 65534
=A1/1 is still 100000
=A1/2 retuns 32767.5
Using MAX() on a range appears not to see 100000.

Very Serious!

[Google Groups „microsoft.public.excel“, 22.09.2007 ff.]

Sowas ist gut zu wissen, nicht dass ich mal ewig sitze und da einen Fehler in der Buchhaltungssoftware suche…

Listening To:
Howard Shore – The Lord Of The Rings III (Soundtrack)
Reading (zum x-ten Mal) :
Prof. Christoph Kreitz – Theoretische Informatik II (Vorlesungsskript)