A bug was found in Microsoft's Excel 2007.You see, for some formulas that has an answer of 65535 (like 154.2*425, or 850*77.1), Excel will show 100000 .
Meaning, in any Casio calculator: 850*77.1=65535
In MS Excel 2007: 850*77.1=100000
This is a stupidly inexcusable bug. Speechless!
(Edited 26 Sept @ 12:27: 65535*1 does return the correct number. Thanks to Buzain for the heads-up)
11 comments:
this is absurd. I tested 850*77.1 and it gave 100000 but 65535*1 gave the correct value.
it works fine for me. maybe you need an updated version :p
Dear Buzain
You are correct. My apologies. I will correct this in the main post immediately. However, try these:
=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
A poster on the linked page said this:
"Suppose the formula is in A1.
=A1+1 returns 100001, which appears to show the formula is in fact 100000
And if you multiply by 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 returns 32767.5
Using MAX() on a range appears not to see 100000. "
Ammar
Are you using Excel 2007? Everyone is having this problem.
This is unbelievable. I showed it ro my colleagues in our financial control department and they were shocked. Using Excel is a religious ritual for these guys and such a defect hurts the hell out of them. I felt so sadistic, but you know what, I really enjoyed it. They deserve to be shocked occasionally :)
Do you have any idea what this means?
It means all financial reports done in Excell 2007 MUST BE CHECKED MANUALLY.
Do you have any idea what a @%$$# headache that is?
I HATE EXCEL!
I HATE EXCEL!
I HATE EXCEL!!!
AAARRRGGGGHHHHHH!
I don't know whether it's just me or does working on Excel for 5 hours straight without a break does that^ to everyone?
:|!
I used to create the most complex and long formulas in excel.
I succeed, but then I get the most evil headaches!
Makes me wonder how many major problems such bugs have caused; after all, so many businesses use it, and if you just blindly assume it will compute properly (which SHOULD be a reasonable assumption)...scary thought! :O
A while back I plotted a line plot on some constant values (e.g. 4, 4, 4, 4) and got a random-looking (i.e. very noisy) plot. Excel is not my favorite program. :)
I wonder how open office and google docs fair...
Hmmm...
Excel 2007 is a step backwards. Anyone who makes charts/graphs in 2003 is likely to HATE the "new and improved" version. 3 weeks with Excel 2007 and I'm about to throw a brick through my screen.
The programmers at MS are really getting disconnected from their typical user, especially business users IMHO. Time for a Mac, I guess.
Post a Comment