Hello,

I am attempting to use a series of AND & OR commands within an IF statement. I believe the issue lies within the PaymentMonth = StartMonth portion of the code below:

'Quarterly Payments
If DayDifference >= 0 _
    And Cells(i, 19) = "In force" _
    And Cells(i, 20) = "Quarterly" _
    And PaymentMonth = (StartMonth _
        Or StartMonth - 3 Or StartMonth + 3 _
        Or StartMonth - 6 Or StartMonth + 6 _
        Or StartMonth - 9 Or StartMonth + 9) _
    And PaymentDay >= StartDay _
    And PaymentDay <= EndDay _
Then
    Cells(i, 9) = "1"
End If
The PaymentMonth variable is an integer representing the current month. The StartMonth is an integer representing the month of payment. The code seems to be registering every month as true. I believe it has something to do with the syntax of my OR statements. Does anyone have any ideas? Thanks for your time.

Steve