I am using Excel 2003 Professional Edition. If you include the following
formula into a cell, it produces a result of 8.74999999999999 if you expand
the decimal places to 16. The correct answer is 8.75. The formula is
((17.15-17)*10/6+17)-((8.3-8)*10/6+8). This only happens if you use 17.15 and
8.3. I came across this when using a process to convert times to decimals
and then subtract one from the other. Anyone have any ideas?
--
BobD