Comparing cells with text
 

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!

Comparing cells with text
 

Try this in C1, and copy down:

=EXACT(A1,B1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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!

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!

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

Comparing cells with text
 

=COUNTIF(A1:B1,A1)=2

"Mortir" wrote:

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!