View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default Comparing cells with text

And that can be simplified to =(B1=A1)

Note, however, that Dave's formula is returning TRUE and FALSE as text
strings. If you want logicals, remove the quote marks. My simplified
version returns a logical result.
--
David Biddulph

"Dave T" wrote in message
...
=IF(B1=A1,"TRUE","FALSE")