View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave T Dave T is offline
external usenet poster
 
Posts: 10
Default Comparing cells with text

=IF(B1=A1,"TRUE","FALSE")

"Mortir" wrote in message
ps.com...
i have the following case:

A B
1 EUR USD
2 EUR EUR
3 EUR CHF

I'd like to compare the two colums and if the two cels in one row
match, i would get a TRUE answer and if not it would be false - as the
following example:

A B C
1 EUR USD FALSE
2 EUR EUR TRUE
3 EUR CHF FALSE

how do I do that?

thanx for your help!