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!