Multiplication Errors in Excel!

[DHC6twinotter]

Anybody hear about this? Guys at work were talking about it.

If you type =850*77.1 in Excel, the answer comes out to 100,000. The correct answer should be 65,535.

From http://it.slashdot.org/it/07/09/24/2339203.shtml :
"Suppose the formula is in A1. =A1+1 returns 100,001, which appears to show the formula is in fact 100,000... =A1*2 returns 131,070, as if A1 had 65,535 (which it should have been). =A1*1 keeps it at 100,000. =A1-1 returns 65,534. =A1/1 is still 100,000. =A1/2 returns 32767.5."

I tried it, and mine is buggered up too. I wonder how many accountants are screwed up with this one! :confused:

Pretty awesome!

[surf4runner]

mine works. got 65535.

[Cebby]

Mine works as it should. Live Update surely took care of this glitch.

[DHC6twinotter]

Are you all using 2007? I just checked for updates on mine, and I'm all up to date. Might just be an issue with 2007. :headscratch:

[arjan]

Mine works fine too, but I am using open office :D

[Robinhood4x4]

DAMMIT!!! That means I just overpaid on those 850 churros that I paid 77.1 cents for!!!

:chair:

[DHC6twinotter]

:lol: Mine still is broke.