IF function comare to identical amount but inconsistent results
 

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

IF function comare to identical amount but inconsistent results
 

For the *same* reason as this:

http://www.mcgimpsey.com/excel/pennyoff.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"skhuon" wrote in
message ...

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