I was using conditional formatting to highlight any cells that didn't match, and I came across a handful where while looking identical the formula was saying they weren't. One columns was a static list, and the other a simple subtraction formal, and I found the issue was somehow the formula to subtract 2 numbers which only go to 2 decimal places was somehow getting an answer which had a value in the 12th decimal place
Below is an example of what I'm seeing, any ideas how I'm getting a 1 at 12 decimal places when the numbers used for the calculation only go to 2 decimal places?
Thanks
E F static =sum(E1-F1)
12044.950000000000000000000000000000 11931.650000000000000000000000000000 113.30 113.30000000000100000000
Bookmarks