Thread
:
IF-SEARCH
View Single Post
#
3
Harlan Grove
Posts: n/a
"Jason Morin" wrote...
=IF(ISNUMBER(SEARCH("-",A1)),"value_1","value_2")
Alternatives.
=IF(COUNTIF(A1,"*-*"),"Yay!","Boo!")
=IF(SUBSTITUTE(A1,"-","")<A1,"Yay!","Boo!")
Reply With Quote