Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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?? |
#2
|
|||
|
|||
Hi!
You were real close. Try either of these: =IF(ISNUMBER(SEARCH("detail",$A$6)),abc,efg) =IF(ISERROR(SEARCH("detail",$A$6)),efg,abc) These will also execute formula "efg" if the cell is blank. If you don't want that to happen: =IF($A$6="","",IF(ISNUMBER(SEARCH("detail",$A$6)), abc,efg)) =IF($A$6="","",IF(ISERROR(SEARCH("detail",$A$6)),e fg,abc)) Biff -----Original Message----- 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?? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|