# Compare 2 excel cells

Hello,
I'm trying to do a simple compare between 2 cells.
I used
=IF(A1=B1,TRUE,FALSE)
=EXACT(A1,B1)
=MATCH(A1,B1)

Nothing seems to give me the correct answers.
Please see attached. (Cells contain numbers and texts).

Any help is appreciated.
sample-compare.xlsx
SOLUTION
Shanan212

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What kind of result do you want?

When I try the =IF(A1=B1,TRUE,FALSE) code in Cell C1 it returns TRUE.
W.E.B

Hello,
NOPE,  will not work,
try line 20 it should say false.
SOLUTION

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try this......

IF(A1=B1,"TRUE","FALSE")
sample-compare.xlsx
like this?

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION

membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can even simplify the formula to

=A1=B1