DHC6twinotter
09-25-2007, 12:17 PM
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!
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!