Help with dummy variable

[Lorna087]

Ok I need help so any contribution would be greatly appreciated. In column A I have different occupations labelled 1,2,3,4 and 5. But I want to create a dummy variable that combines both 2,3 and 4, where the figure 1 would appear if you are a worker within occupations 2,3 and 4, and 0 if not (so 1 if values are true and 0 if not). I've tried using
=IF(COUNT(SEARCH("2,3,4",A2)),1,0) but this doesnt seem to work as I either get all values equal to 1 or 0 not real values.... Any ideas what I'm doing wrong here??

 

[CWatts]

You can use this in another column if that would work for you.

=if(or(a1=2,a1=3,a1=4),1,0)

 

[Lorna087]

Thats great, it worked!! thanks so much for your help!!