Re: Bug in Excel 2007

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Sep 24, 11:41 pm, "michael.e.br...@xxxxxxxxx"
<michael.e.br...@xxxxxxxxx> wrote:
On Sep 24, 10:11 pm, mega...@xxxxxxxxx wrote:

This is simple rounding error. Down at the hardware level of PCs,
when working with floating point numbers, you are only guaranteed a
number of significant digits (varies depending on the size of the data
type). In this case, your numbers are good up to 7 digits (NNNNN.NN),
which fits with the double data type in C.

Complete and utter BS. As pointed out, the Excel representation holds
absolutely nothing in common with either the computers native FP
result, nor with the IEEE standard for floating point.
--
MB



On Sep 23, 9:25 am, "Dana DeLouis" <ddelo...@xxxxxxxxxxxxx> wrote:

I also see that Excel 2007 still has this over 10+ year bug still in it:

=40000.223
=41000.348
=52000.723

Such numbers are converted to:

=40000.2229999999
=41000.3479999999
=52000.7229999999

--
Dana DeLouis

"Molham Serry" <mse...@xxxxxxxxxxxxxx> wrote in message

news:834DAE15-EE9C-4996-A63B-2C443F09F604@xxxxxxxxxxxxxxxx

Simply when you try to multiply 850 by 77.1 excel display the result to be
100000 !!!

The bug is from the FPU, excel just converts its own algorithm to
transfer it to text wich strips the data from a double.

And the 65565 bug is probally caused by an optimisation that causes
excel to use the smallest data type possible to store data (thus
saving a LOT of memory space), but this time they must have messed it
up.

.

Relevant Pages

  • Re: INT defect: Please try this on 2007 for me
    ... binary floating point representation and calculations. ... the low-order bits you should not be using Excel. ... as 40000.847999999 when formatted to 15 significant digits. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: INT defect: Please try this on 2007 for me
    ... Not that I would object to a calculation option that would do just that, namely: force the result of all formulas to be rounded to 15 significant digits, not unlike the "Precision as displayed" option, but more generally applied. ... That would legitimatize some of the heuristics that Excel has implemented to try to ameliorate the aberrations due to binary floating point arithmetic. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: INT defect: Please try this on 2007 for me
    ... calculations Excel is performing under the covers, ... Most real-world spreadsheets contain a chain of calculations where the ... significant digits. ... binary floating point arithmetic. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Bug in Excel 2007
    ... number of significant digits (varies depending on the size of the data ... which fits with the double data type in C. ... nor with the IEEE standard for floating point. ...
    (microsoft.public.excel)
  • Re: Bug in Excel 2007
    ... number of significant digits (varies depending on the size of the data ... which fits with the double data type in C. ... nor with the IEEE standard for floating point. ... Are you saying excel doesn't use the FP processor? ...
    (microsoft.public.excel)