Using AND/OR functions together - help please

[beerjjj]

Hi All,

I'm trying to get this formula to work but with no success.

I'm wanting to get this to return either True or False if the Quarter and Month met the require criteria of say Q1 '15 and the month is either Jan, Feb or Mar.

Excel.PNG

The formula I'm using in Column C is - =IF(AND(A2="Q1 '15",(OR(B2=MONTH(1),B2=MONTH(2),B2=MONTH(3)))),"TRUE","FALSE"))

Thanks - Jason