Hi all,
i have a very strange problem. SUM isn't returning accurate value. In this example (attached) I am doing a simple calculation of 2 cells (67.34 x 0.04, which should be 2.69, but excel keeps returning rounded up value 3.00. No formatting options I have tried change this. Even if I simply the function at 0.04 or move it to a different cell, excel keeps showing 3.0. The calculation works correctly when I remove function from 0.04 value and simply type 0.04. Then excel shows 2.69 result.
Thanks for any advice.
Bookmarks