How to set formula equal to a series of numbers

[clif]

Dear all,

How to set formula equal to a series of numbers.

If cells(1,1) = {1,3,5,7,9} Then

Else

EndIf

Thanks!