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.

 

[steve the fish]

Re: mutliple if statements

You could do with some brackets:

If (Cells(j, 30) >= 2 And Cells(j, 26) >= 6) Or (Cells(j, 30) = 1 And Cells(j, 26) <= 5) Then

 

[Godders199]

Re: mutliple if statements

If (Cells(j, 30) >= 2 And Cells(j, 26) >= 6) Or (Cells(j, 30) = 1 And Cells(j, 26) <= 5) Then

Still gets a runtime error 13 - type mismatch.

 

[steve the fish]

Re: mutliple if statements

Thats probably the data not the code. What is in these cells?

 

[Cat129]

Re: mutliple if statements

- Sorry ignore this, I clicked reply by accident and couldn't delete it

 

[Godders199]

Re: mutliple if statements

Hi, previously it was as follows and worked correctly, have just added the and (j,26) element , this cell has a formula to work out the number of months between two dates. formatted as a number. the code saves after this

If Cells(i, 30) >= 2 Or Cells(i, 6) = 0 Then Cells(i, 31).Value = "On Target" Else Cells(i, 31).Value = "Off Target"

 

[BarryL]

Re: mutliple if statements

are you using "j" or "i" as a variable?

 

[Godders199]

Re: mutliple if statements

sorry, i had to change it to J..

 

[Fluff]

Re: mutliple if statements

I suspect that one of the formulae in col J is returning an error.

 

[Godders199]

Re: mutliple if statements

thanks for your help, i have got it to work correctly no.