W.E.B
asked on
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello,
NOPE, will not work,
try line 20 it should say false.
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.
ASKER CERTIFIED 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.
You can even simplify the formula to
=A1=B1
=A1=B1
ASKER
That was it,
the automatic calculations was disabled
thanks for all.
the automatic calculations was disabled
thanks for all.
When I try the =IF(A1=B1,TRUE,FALSE) code in Cell C1 it returns TRUE.