multiple if statements

[Godders199]

Hello, I am trying to get the following statement to work, but I get a debug, based on the code up to then... can someone tell me what i need to change to get this to run. effectively there are two scenarios which should return "on target".

If Cells(j, 30) >= 2 And Cells(j, 26) >= 6 Or Cells(j,30) = 1 And Cells(j, 26) <= 5 Then Cells(j, 31).Value = "OnTarget" Else Cells(j, 31).Value = "Off Target"
any help or ideas would be appreciated.

 

[Fluff]

Re: mutliple if statements

Glad it's working & thanks for the feedback