Thread: How do I compare the data in Cell A1 with the data in Cell A2
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default 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.
Reply With QuoteReply With Quote