Using the If function for text

[Guest]

I am having trouble with the if function for comparing two cells with the
same text. The function will not recognize the two cells as the same text
and sends back false than true. Does anyone knows why this is happening.
Thanks

 

[Bob Phillips]

Are there are leading trailing spaces. Try

=IF(TRIM(A1)=TRIM(B1),...

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

They must be the with regard to the number of trailing or leading blanks as
well as text characters

 

[Guest]

A1: Apple
B1: apple

for case sensitive use
=EXACT(A1,B1)
It returns FALSE

for case not sensitive use
=A1=B1
It returns TRUE