I tried to compare the amount of 2 colums (10 rows) because and ithey are the same amount extracted from 2 different sources.
Here is my function =IF(B7=E7,TRUE,False)
Some rows came out to be True, however, I get some "False" results and when I eye-balled the two amounts, they are identical. So I am not sure why two identical amounts would give me "false" results. I tried to format both columns to 2 decimal places and it still doesn't work.
Can someone please tell me how to fix this problem?
Thanks so much.
Bookmarks