I have a quantity of values listed in one column. The values range from 0.0018 to 22,620.0000
The last cell (A3859) has the formula =SUM(A1:A3858).
Changing the order of the values (ex: ascending to descending) causes the sum of the values to change
(ex: 973,867.904500000 to 973,867.904499998).
WHY?
Because I am talking about only one column of data and changes in the fourth decimal place, this may seem unimportant. However, this example is taken out of a very large analysis that I am doing which involves using "=EXACT" and conditional formatting. These are compromised by the fractional changes in sum.
Thanks,
ctb
The last cell (A3859) has the formula =SUM(A1:A3858).
Changing the order of the values (ex: ascending to descending) causes the sum of the values to change
(ex: 973,867.904500000 to 973,867.904499998).
WHY?
Because I am talking about only one column of data and changes in the fourth decimal place, this may seem unimportant. However, this example is taken out of a very large analysis that I am doing which involves using "=EXACT" and conditional formatting. These are compromised by the fractional changes in sum.
Thanks,
ctb