Combining 2 conditions into one formula

[Brew]

How do I express the following as a single formula:

If J2=15,17,19,21,23,25,27 and Q2=1, then 1, if false, then 0

 

[Andrew Poulsom]

How about?

=AND(ISNUMBER(MATCH(J2,{15,17,19,21,23,25,27},FALSE)),Q2=1)+0

 

[Lewiy]

Try this:

=AND(J2>=15,J2<=27,MOD(J2-1,2)=0,Q2=1)+0

 

[Brew]

Thank you!!!