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
When I try the =IF(A1=B1,TRUE,FALSE) code in Cell C1 it returns TRUE.