|
Same contents but not equaled
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 |
Same contents but not equaled
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 |
Same contents but not equaled
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 |
Same contents but not equaled
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 |
Same contents but not equaled
Tell me what you get from these two formulas
=A1=B1 and =LEFT(A1,4)=LEFT(B1,4) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "MFS" wrote in message ... 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 |
Same contents but not equaled
Hi Bernard,
I will give you the sample after I try Mikes 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 -- MFS22 "Bernard Liengme" كتب: Tell me what you get from these two formulas =A1=B1 and =LEFT(A1,4)=LEFT(B1,4) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "MFS" wrote in message ... 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 |
Same contents but not equaled
Hi,
I tries Mikes suggestion and yours, both of them helped me. Thanks a lot. -- MFS22 "Bernard Liengme" كتب: Tell me what you get from these two formulas =A1=B1 and =LEFT(A1,4)=LEFT(B1,4) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "MFS" wrote in message ... 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 |
| All times are GMT +1. The time now is 08:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com