Re: Bug in excel fundamantal add-function
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Wed, 17 May 2006 14:14:39 -0400
Briefly, it is because Excel does not add using decimal arithmetic.
On Wed, 17 May 2006 07:06:02 -0700, Boy_alone_18
<Boy_alone_18@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
can you explain to me why the sum() of 2 decimal numbers can have 13 decimal
like
(A1) 5384754,23
(A2) 1294830,46
(A3) 1583569,98
(A4) 2506349,21
(A5) 3,45
(A8) =A1-A2-A3-A4-A5
(A8=) 1,130000001
all this number are finite number.
thank,s
"JE McGimpsey" a écrit :
No, it's not a bug. It's a "feature" of XL using IEEE double precision
floating point math. Most numbers can't be exactly represented in a
finite number of binary digits, just as 1/3 can't be exactly represented
by a finite number of decimal digits.
You can use ROUND() to round to zero if it's necessary.
See
http://cpearson.com/excel/rounding.htm
In article <1142809137.754056.127350@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
"snooze" <kze@xxxxxxxxxxx> wrote:
A7 must be 3 - but try to have 13 decimals...!!! is this a BUG? I think
so
--ron
.
- Prev by Date: Re: Sorting data into a new column
- Next by Date: Using MATCH and INDEX to extract unique values
- Previous by thread: Removing / from date
- Next by thread: Using MATCH and INDEX to extract unique values
- Index(es):
Relevant Pages
|
