View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lea from CA[_2_] Lea from CA[_2_] is offline
external usenet poster
 
Posts: 10
Default search for multiple strings

Here is my current formula =IF(ISERROR(SEARCH("move",D4)),0,E4). Now I want
to also search for "carryforward" in cell D4. How can I do that?