MS Excel 2007 doesn't know how to calculate
-
Cute bug there. If the figure is somewhere near 65536, it will screw up and give you an odd answer.
Those who have Excel 2007 can try it out.
http://ap.google.com/article/ALeqM5j7HWSNLp5sHqZDXPrYNSgDZcddnAD8RUIGB80
http://blogs.msdn.com/excel/ -
doesnt seem to affect my excel 2000.
this reminds me of the old pentium floating point bug..... -
It doesn't affect old versions of Excel, just Excel 2007 only.
-
the newer the more bugs?
-
Maybe. But surprisingly, it only happens to the number 65536. Other numbers turn out OK.
-
can wad
proof:
maybe cos i using vista? -
Huh?Originally posted by wishboy:can wad
proof:
[IMG]http://i84.photobucket.com/albums/k26/wishboyz/Untitled.jpg[/IMG]
maybe cos i using vista?
Did you just type in those figures?
Do some calculations of figures that are near 65536. Like 10.0 X 6553.6 -
it is soooo laggy running on VISTA, (maybe need more ram)Originally posted by ndmmxiaomayi:It doesn't affect old versions of Excel, just Excel 2007 only. -
more proof:
-
Heh, weird. Vista no problems?Originally posted by wishboy:
How about trying some of the calculations in the AP article? -
lol wth...
16,383.75 * 4
excel gives the answer in 2 d.p. , somemore got comma
ok the calculation in the AP article are the only ones with bug i think -
who have microsoft office 2007 home and student ect (cannot enterprise) can be a good soul help me
pm me for more details