IF-SEARCH

G

Guest

I want to search a text/number string to see if it has a dash "-" and if it
does, I want to insert a value and if it doesn't, I want a different value

I tried...
IF(SEARCH("-",A2)>0
....which works fine if the string does have a dash, but bombs to #VALUE!
errror if the string does not have a dash

Any help appreciated!
 
H

Harlan Grove

Jason Morin said:
=IF(ISNUMBER(SEARCH("-",A1)),"value_1","value_2")
Click to expand...

Alternatives.

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell to have comma-delimited values based on text 8
How do I find a dash in a cell with numbers in it in excel. 9
If formula 5
Displaying zeros in cells 2
Handling Dashes in IF statement 3
IF Function 4
Fill Handle 6
See if cell value appears within a value range given by another cell. 9

Top