No I am trying to write it in VBA and I'm not really sure ho wto do that.

Thanks though

"Jarek Kujawa" wrote:

e.g.
=IF(OR(A1=1,A1=3,A1=7);1,0))
if you mean a formula