The error is in the 14th decimal place??? That is almost certainly
round-off error resulting from the computer using binary numbers. I
found the following articles by searching on Google for rounding error
binary:
http://www.cpearson.com/excel/rounding.htm
http://support.microsoft.com/default...kb;en-us;78113
Here's something to try:
In and adjacent column, multiply the values in question by 100, to
eliminate fractions
Sum these values
Divide by 100 to get back to dollars and cents.
See if the extraneous digits are gone.
--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile:
http://www.excelforum.com/member.php...o&userid=22181
View this thread:
http://www.excelforum.com/showthread...hreadid=381265