| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vary response IF certain text is contained in a cell
Hi All I need a formula which says this : If the text 'AB' is contained anywhere in E2 , put 'Yes'. If not put 'No'. Can someone help with this? Best Wishes |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vary response IF certain text is contained in a cell
=IF(ISERROR(FIND("ab",E2,1)),"No","Yes") "Colin Hayes" wrote: Hi All I need a formula which says this : If the text 'AB' is contained anywhere in E2 , put 'Yes'. If not put 'No'. Can someone help with this? Best Wishes |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vary response IF certain text is contained in a cell
In article , Atishoo
writes =IF(ISERROR(FIND("ab",E2,1)),"No","Yes") Hi OK Thanks for getting back. I'm trying to incorporate the first part of the code above into my existing formula : =IF(D2<=20,J2,IF(J2=2,6,IF(OR(J2=1,J2=11),5,J2))) Instead of saying 'if D2 is greater or equal to 20' , I need to say 'If E2 contains AB'. The 'Yes' and 'No' replies from above would not be needed therefore. I keep getting errors. Can you advise? Thanks again. Best Wishes "Colin Hayes" wrote: Hi All I need a formula which says this : If the text 'AB' is contained anywhere in E2 , put 'Yes'. If not put 'No'. Can someone help with this? Best Wishes |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vary response IF certain text is contained in a cell
Hi
=IF(isnumber(search("ab",E2,1)),J2,IF(J2=2,6,IF(OR (J2=1,J2=11),5,J2))) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Colin Hayes" wrote in message ... In article , Atishoo writes =IF(ISERROR(FIND("ab",E2,1)),"No","Yes") Hi OK Thanks for getting back. I'm trying to incorporate the first part of the code above into my existing formula : =IF(D2<=20,J2,IF(J2=2,6,IF(OR(J2=1,J2=11),5,J2))) Instead of saying 'if D2 is greater or equal to 20' , I need to say 'If E2 contains AB'. The 'Yes' and 'No' replies from above would not be needed therefore. I keep getting errors. Can you advise? Thanks again. Best Wishes "Colin Hayes" wrote: Hi All I need a formula which says this : If the text 'AB' is contained anywhere in E2 , put 'Yes'. If not put 'No'. Can someone help with this? Best Wishes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding the cell if text is contained within | Excel Discussion (Misc queries) | |||
| Adding the cell if text is contained within | Excel Discussion (Misc queries) | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| find partial text contained in another cell | Excel Discussion (Misc queries) | |||
| searching a cell for a contained text word | Charts and Charting in Excel | |||
Linear Mode
