[GLLUG] More Excel accuracy woes

[Michael George]

Huh, dunno...  I have Office 2003 here at work and Excel displays 65535
for those calculations.  Maybe a faulty MPU or an older version of Excel
is at fault.

On Tue, September 25, 2007 2:44 am, Michael Rudas wrote:
> Michael Corral of the MDLUG list posted this information.  The linked
thread is VERY interesting... I wonder if this behavior is OOXML
compliant-- heh.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Last year I posted about Excel 2002 (and earlier versions) not being
able to calculate standard deviations correctly. Excel 2003 fixed that
particular problem.  But it looks like Excel 2007 has an even more
serious accuracy issue.  Take a look here:
> <http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/2bcad1a1a4861879/2f8806d5400dfe22?hl=en#2f8806d5400dfe22>
>
> Apparently, a lot of calculations that come out to 65,535 will show
100,000 to be the answer!  For example, 850*77.1.  Man, I sure hope no
one is depending on Excel for accurate calculations.
>
> I can confirm that StarOffice 7 does *not* have that bug. Even with the
easter eggs it still calculates accurately! :-)
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> This reminds me of that old saying about bureaucracy: " A camel is a
horse designed by a committee."
>
> -- Mikey
> _______________________________________________
> linux-user mailing list
> linux-user at egr.msu.edu
> http://mailman.egr.msu.edu/mailman/listinfo/linux-user
>


-Michael George
 Ideal Solution, LLC



-Michael George
 Ideal Solution, LLC

-Michael George
 Ideal Solution, LLC