26 September, 2007

Excel is the most expensive useless calculator

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:

BuZain said...

this is absurd. I tested 850*77.1 and it gave 100000 but 65535*1 gave the correct value.

Ammaro said...

it works fine for me. maybe you need an updated version :p

Redbelt said...

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.

BuZain said...

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 :)

Redbelt said...

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?

Manutdfanatic said...

I HATE EXCEL!

I HATE EXCEL!

I HATE EXCEL!!!

AAARRRGGGGHHHHHH!

Manutdfanatic said...

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?



:|!

Redbelt said...

I used to create the most complex and long formulas in excel.
I succeed, but then I get the most evil headaches!

Anonymous said...

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. :)

Redbelt said...

I wonder how open office and google docs fair...
Hmmm...

Anonymous said...

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.