IF function comare to identical amount but inconsistent results

  • Thread starter Thread starter skhuon
  • Start date Start date
S

skhuon

I tried to compare the amount of 2 colums (10 rows) because and ithe
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 an
when I eye-balled the two amounts, they are identical. So I am not sur
why two identical amounts would give me "false" results. I tried t
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF function compare to identical amount but inconsistent results 3
IF function with too many arguments 3
IFISTEXT() function problem 6
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 2
Copying "Exact" Function 2
Cell to the left of an Index function result 2
Need VBA Code/Marcos To Hide Less than zero amounts. Not a filter 1
DBSUM function but with function as criterion, not a range 3

Back
Top