=850*77.1 (a simple multiplication formula)
If you calculate this using a normal calculator, the correct result should be 65535, but in Excel 2007, it was calculated as 100000. Is this one of Microsoft's hidden easter egg? I don't think so, since this behavior is only at Microsoft Excel 2007. I tried this on 2003 and it worked like normal. I also tried this on OOo and it calculated correctly. Any ideas where this number came from? I really have no idea
Update (27 September 09:00 AM) : It seems that not only the above sample that works, but there are some other examples. Like this one:
=4.1-2*2
If you just write down, it may display the correct answer, 0,1 (or 0.1 in some countries, due to separator difference), but what happened when you format the cell and ask them to display 17 digits after the separator? You will get 0.09999999999999960, and not 0.1 anymore (well, if that number is rounded, you still get 0.1, but does it should be a 0.10000000000000000 ??)
Well, Microsoft has noticed this and wrote a description about this bug and they are working on the solutions (Thanks to Fajran) and Joel On Software also wrote about this bug and showing his experience working back with Excel team few years ago. It's quite technical, but i think you will get it
Here's the screenshot:
pasti bajakan
ReplyDeletesee http://blogs.msdn.com/excel/
ReplyDeletekayaknya gak cuma bajakan, tapi juga semua versi Excel 2007 (lihat blog yang dikirimkan oleh mas Fajran)
ReplyDeletera duwe office2007 dadi ra iso ngetest :P
ReplyDeletethis is not the first time. if paper can do then ditch the Excel :D .... I would rather use paper brain and sipoa hahahahaa *ngacirrr
ReplyDeletePerhaps 2003 is better than 2007 for calculation process. UI in 2003 is also better then 2007 (it's just a matter of habit i guess)
ReplyDeleteUdah lihat "50 JURUS RAHASIA EXCEL"? itu bukunya XL-mania, forum yahoo Microsoft Excel terbesar di dunia.
ReplyDeleteDi situ dijelasin kalo SEMUA versi excel bisa salah berhitung. Jadi bukan Excel 2007 aja.
This week I have seen a lot of excel files. Some of them were corrupted and I didn't know what to do then. I was upset. But enexpectedly my brother called me up and advised - recover Excel file xlsx. It helped me for seconds and without money as I kepy in mind. I have been using for short time,but it likes me.
ReplyDelete