The Windows calculator is documented to give at least 32 decimal digit
accuracy--probably IEEE quadruple precision, which is far more than the IEEE
standard double precision used by Excel and most other numeric software.

The 16th digit in 2179,0089519999972104171 is a 7, which rounds up to give
2179,00895100000 to 15 digits, but Excel does not display trailing 0's
beyond the decimal point, unless explicitly formatted to do so.

Jerry

"Claudio" wrote:

|I don´t understand. In the Windows Calculator the result is presented
2179,0089519999972104171 and if in the Excel's precision is
15 significant figures, but the number 2179.008952 dont´t have 15 digits.

Why in Excel is the number 2179.00895199999 nearest to the number
2179.00895200000.
Each digit number would not be one? Even that was 15 digits (15 numbers)
would have to show up 2179.0089519999 considering the point

"David Biddulph" wrote:

What calculation is giving you 2137.63308348257 ?
And where do you get 2137.6330834825731 ?
Doesn't 1.0198424825731 * 2136.613241 come to something a lot closer to the
OP's 2179.008952 ?
--
David Biddulph

"Bob I" wrote in message
...
Actually Excel produces

2137,63308348257

as opposed to

2137,6330834825731

which is due to the limit of precision available in Excel.

Claudio wrote:

This problem also occurs in Excel 2007.

"Claudio" wrote:


Suppose cell A1 = 1,0198424825731 (thirteen decimal places after comma)
and cell B1 = 2136,613241 (six decimal places after comma) the result is
presented in Excel = 2179,008952 (only six decimal places after comma)
and should be presented the following results = 2179,00895199999.

After a six decimal places is presented 000000 (zeros)

"David Biddulph" wrote:


It's no good just saying vaguely: "... are not correct"
Tell us what formula you used, what numbers were the inputs to that
formula, what answer you got, and what answer you expected.
--
David Biddulph

"Claudio" wrote in message
...

Even making calculations only by the Excel submitted figures are not
correct
from the 6 decimal place, and I updated with Office (last SP), which
can be?

Other e-mail for contact: