If text = text, then Yes

[webryan]

Hello,

I have "A" (as text) in A1, and "B" (as text) in B1.
I put in the formula
=IF(A1=B1,Yes,No)

What I want it to do is that if the text in A1 is the same as in B1, then "Yes",
but if not, then "no".

I get a #NAME! error when I try this in excel.


Thank you very much for your help.

[Andrew-R]

Try:

=IF(A1=B1,"Yes","No")

[webryan]

Well, that was simple.
That works like I wanted it to.
Thank you,