multiple if statements

Godders199

Active Member
Joined
Mar 2, 2017
Messages
313
Office Version
  1. 2013
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.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Re: mutliple if statements

You could do with some brackets:

Code:
If (Cells(j, 30) >= 2 And Cells(j, 26) >= 6) Or (Cells(j, 30) = 1 And Cells(j, 26) <= 5) Then
 
Upvote 0
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.
 
Upvote 0
Re: mutliple if statements

Thats probably the data not the code. What is in these cells?
 
Upvote 0
Re: mutliple if statements

:confused: - Sorry ignore this, I clicked reply by accident and couldn't delete it
 
Last edited:
Upvote 0
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"
 
Upvote 0
Re: mutliple if statements

are you using "j" or "i" as a variable?
 
Upvote 0
Re: mutliple if statements

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

Forum statistics

Threads
1,224,823
Messages
6,181,176
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top