Thread: Vary response IF certain text is contained in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Atishoo Atishoo is offline
external usenet poster
  
Posts: 267
Default 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




Reply With QuoteReply With Quote