Using the If function for text

R

ranwadischool

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
 
B

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

Gary''s Student

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

Teethless mama

A1: Apple
B1: apple

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

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