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