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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I compare the data in Cell A1 with the data in Cell A2 (https://www.excelbanter.com/excel-discussion-misc-queries/195438-how-do-i-compare-data-cell-a1-data-cell-a2.html)

dfwguy

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

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[_2_]

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

=IF(A1=B1,TRUE,FALSE)
--
John C

"dfwguy" wrote:

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.

Mike H

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

Maybe a bit shorter

=A1=B1

Mike

"John C" wrote:

=IF(A1=B1,TRUE,FALSE)
--
John C

"dfwguy" wrote:

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.

dfwguy

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

Thanks a Million!!

"John C" wrote:

=IF(A1=B1,TRUE,FALSE)
--
John C

"dfwguy" wrote:

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.

All times are GMT +1. The time now is 08:41 AM.