Alan!]
3. If you lot add together 1 to a jail cellular telephone that has i of these wrong results you lot larn 100001, but deduct 1, as well as you lot larn 65,534!
4. Displays right lawsuit inwards Microsoft Excel 2000 as well as 2003. So it appears to live on an number infesting Excel 2007 alone!
5. Even SUMPRODUCT returns 100000!
=SUMPRODUCT(850,77.1)
3. If you lot add together 1 to a jail cellular telephone that has i of these wrong results you lot larn 100001, but deduct 1, as well as you lot larn 65,534!
4. Displays right lawsuit inwards Microsoft Excel 2000 as well as 2003. So it appears to live on an number infesting Excel 2007 alone!
5. Even SUMPRODUCT returns 100000!
=SUMPRODUCT(850,77.1)
=SUMPRODUCT(850,77.1,2,0.5)
Let me Analyze the Error:
Did you lot detect the peculiarity well-nigh the error? This happens for closed to multiplication formula that should evaluate to 65,535! Like,
=5.1*12850
=10.2*6425
Let me Analyze the Error:
Did you lot detect the peculiarity well-nigh the error? This happens for closed to multiplication formula that should evaluate to 65,535! Like,
=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 as well as and so on… Here is a screenshot depicting the weird calculation!
So it appears to me that it the specialty of the number 65,535 that makes the fault unique! Interestingly enough, 65,535 is the highest number which tin live on represented yesteryear an unsigned xvi chip binary as well as 65,536 requires 32 bits. In other words, the number, 65,535, happens to accept 2 bytes worth of 1 digits inwards binary. I understand, Microsoft Excel 2007 powerfulness live on using floating indicate for numbers, as well as thence it powerfulness non employ here, notwithstanding I doubtfulness this has got a lot to work amongst this error! Bugs are ordinarily encountered at boundaries. I wonder how the exam squad at Microsoft, who were testing the multiplication feature, could missy out such an obvious looking test! Also I am interested to reckon how Microsoft is going to react to this bug!
Can you lot reckon closed to to a greater extent than interesting attributes of this error? Can you lot link this to another testing perspective? Do allow me know your viewpoints on this yesteryear leaving your comments.
Happy Testing…
More interesting articles here :Tutorial Software Sumber : http://www.softwaretestingtricks.com/
So it appears to me that it the specialty of the number 65,535 that makes the fault unique! Interestingly enough, 65,535 is the highest number which tin live on represented yesteryear an unsigned xvi chip binary as well as 65,536 requires 32 bits. In other words, the number, 65,535, happens to accept 2 bytes worth of 1 digits inwards binary. I understand, Microsoft Excel 2007 powerfulness live on using floating indicate for numbers, as well as thence it powerfulness non employ here, notwithstanding I doubtfulness this has got a lot to work amongst this error! Bugs are ordinarily encountered at boundaries. I wonder how the exam squad at Microsoft, who were testing the multiplication feature, could missy out such an obvious looking test! Also I am interested to reckon how Microsoft is going to react to this bug!
Can you lot reckon closed to to a greater extent than interesting attributes of this error? Can you lot link this to another testing perspective? Do allow me know your viewpoints on this yesteryear leaving your comments.
Happy Testing…