Hi,
Maybe you have spaces, try this
=IF(TRIM(A1)=TRIM(B1),"Yes","No")
Mike
"MFS" wrote:
Hi,
Conceder A1 and B1 are text, which is R123 for example.
IF(A1=B1;"Yes";"No")
The formula is saying that if A1=B1, if true give me Yes, if false give me No.
But the result is No, how it becomes false?? That is my question
--
MFS22
"Bernard Liengme" كتب:
Is this really what you have or are you simplifying it for us?
What is displayed in A1 and B1? Are they numbers?
What is the result of =A1=B1 (should be TRUE)
If you wish, please, send me sample file - email address is on my website
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"MFS" wrote in message
...
Hi all,
The problem is that I have to cells which have the same contents, but
Excel
dose not recognize them as equaled cells?
Please check this example and help me.
A1=R123.
B1=R123.
C1=IF(A1=B1;"Yes";"No")
The result is No,, I could not understand this.
Please help me.
--
MFS22