View Single Post
  #1   Report Post  
John Grossman
 
Posts: n/a
Default Find a word and then take certain action, else

I will have one of two statements - the first one might contain the word
"detail" and the second the word "ASIN". If the word "detail' is present
(i.e. http://www.xyz.com/exec/obidos/tg/detail/-/0934419345/ ) then execute
formula abc else execute formula efg.

Note sure how to handle verification of of "detail"
=if(find("detail",a6)="detail",abc,efg)
Tried this = but not working??