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")
|