More than one "IF" condition

[merryperson]

I have a column of numbers and have created a new column to report the formula.

What I need to do is search the column and report back if the column contains 9335,9333 or 9338.I can do this using the formula =IF(E2=9335,9335,0) to get the one search result but how do I add the search for 9333 and 9338 as well as 9335?

For example my formula picks up
Expn Result
9335 9335
9333 0
9304 0
9335 9335
9338 0
9304 0
9335 9335

What I want is tha search for 9333,9335 and 9338
Expn Result
9335 9335
9333 9333
9304 0
9335 9335
9338 9338
9304 0
9335 9335

I hope this makes sense
Thanks

 

[Special-K99]

in F2
=IF(OR(F2=9333,F2=93358,F2=9338),E2,0)
and copy down column F

 

[merryperson]

W

 

[merryperson]

Works a treat thanks