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