I have a budget spreadsheet with a column of SUMS. This column is then totaled in one cell A10. All numbers rounded to the nearest two decimals. I then create cell A11 which is the same number as A10. Just typed in though, not drawn from any other cell.
I then setup a SUM that subtracts A11 from A10. Despite the fact that both numbers appear the same the result is not ZERO but negative -$0.01. What can I do to get an accurate result?
Bookmarks