How do I compare the data in Cell A1 with the data in Cell A2

dfwguy · Jul 18, 2008

I know this is probably real simple. I need a way to compare data in cell A1
with data in cell B1 and give me a true / false response in cell C1.

John C · Jul 18, 2008

=IF(A1=B1,TRUE,FALSE)

Mike H · Jul 18, 2008

Maybe a bit shorter

=A1=B1

Mike

John C said:
=IF(A1=B1,TRUE,FALSE)

dfwguy · Jul 18, 2008

Thanks a Million!!

John C said:
=IF(A1=B1,TRUE,FALSE)