I have a spreadsheet cell that compares 2 values and produces a message depending on whether the values are the same or not. The formula is
=IF(G196=0,"OKAY","ERROR") and is shown on the attachment.
As can be seen, the value is 0.00 and so the message should be 'OKAY' but I receive the ERROR message. I have checked the values that are being compared to 20 decimal places and the are the same and so the formula =IF(Summary!C6="","",E196-Summary!D37) should be zero to 20 decimal places.
However when I expand the value 0.00 to 20 decimal places there is a value that is not exactly zero as shown on the second attachment.
I do not understand why the subtraction of 2 numbers that are exactly the same (to 20 decimal places) should produce a small difference when subtracted.
Please help.
Bookmarks