Same contents but not equaled

  • Thread starter Thread starter MFS
  • Start date Start date
M

MFS

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.
 
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
 
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
 
Tell me what you get from these two formulas
=A1=B1
and
=LEFT(A1,4)=LEFT(B1,4)

best wishes
 
Hi Bernard,
I will give you the sample after I try Mike’s suggestion and yours
To be honest I did not expect that I will need to provide a sample, because
I have the file in another PC
 
Back
Top