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

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)



"ranwadischool" wrote in message
...
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

They must be the with regard to the number of trailing or leading blanks as
well as text characters
--
Gary''s Student - gsnu200752


"ranwadischool" wrote:

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

A1: Apple
B1: apple

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

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


"ranwadischool" wrote:

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