Excel Formula Test If Value Matches any Item In An Array Or Range

[goss]

Hi all,

Using Excel 2013,

It trying to see if the Month() of a date is in a Array / Range

I tried =IF(MONTH(E8)={2,6,9,11},"Yes","No") where E8 = 9/30/12
I did not get the answer I expected.
What am I doing wrong?

thx
w

[martindwilson]

use or
=IF(OR(MONTH(E8)={2,6,9,11}),"Yes","No")

[goss]

Perfect!

Thanks Martin