Posted on Wednesday, 26th September 2007 by Auw Jimmy

I got information from my friend yesterday about multiplication bug in Excel 2007. You can also search from Google with keyword “excel bug 100000″ or similiar.

Some multiplication result produce 100000 instead of correct number.

Let’s say: 1.9 x 34492.10526 should produce 65535, but Excel 2007 produces 100000.

I think it’s related with 65535 (FFFF hexadecimal). I also check with FF (255), FFFFFF (16777215), and FFFFFFFF (4294967295) but no problem found so far.

I try with some numbers (see below and you can check the result). It happens only on certain numbers and I just can’t find the reason why

Notes:
    A. Raw number
    B. Raw number (65535 divided by the A column)
    C. The result from AxB (I revert the result, so I multiply back the B with A).                  Normally, it should produce 65535, not 100000!)

Posted in IT/Gadget | Comments (3)

3 Responses to “Excel 2007 Multiplication Bug”

1. bayus Says:
   September 29th, 2007 at 20:11

   mungkin subliminal message dari m1cr0s0ft, jim?

   
   
   
2. Jimmy Auw Says:
   September 30th, 2007 at 10:45

   If it’s subliminal, why don’t pick better number then? 666 or 777 should be better

   
   
   
3. Andrie Says:
   October 2nd, 2007 at 13:44

   Excel 2007 aja ya bos?

   
   
   

Leave a Reply