Thread: IF-SEARCH
View Single Post
  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

"Jason Morin" wrote...
=IF(ISNUMBER(SEARCH("-",A1)),"value_1","value_2")


Alternatives.

=IF(COUNTIF(A1,"*-*"),"Yay!","Boo!")

=IF(SUBSTITUTE(A1,"-","")<A1,"Yay!","Boo!")