Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) |