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.