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.


--
skhuon
------------------------------------------------------------------------
skhuon's Profile: http://www.excelforum.com/member.php...o&userid=36902
View this thread: http://www.excelforum.com/showthread...hreadid=566176