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
Microsoft Excel
Last Comment
W.E.B
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
like this?
![example1]()
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.