View Single Post
  #1   Report Post  
Mike A
 
Posts: n/a
Default Subtracting decimals

Why is this? ...
In Excel if I subtract, for example, 1282.39 from 1282.40, and the answer
cell is displayed with 14 or more decimal places, the result displays as
0.00999999999999, when in fact the correct result, obviously, is exactly
0.01. What's happening here, and how do I prevent it?
Thanks.