Thread: FORMULA NEEDED
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mudraker[_3_] mudraker[_3_] is offline
external usenet poster
  
Posts: 1
Default FORMULA NEEDED

It may not be the best formula but it works

=IF(ISERROR(FIND("ok",A1,1)),IF(ISERROR(FIND("allr ight",A1,1)),"No","Yes"),"Yes")


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24672

Reply With QuoteReply With Quote