Conditional Logic VBA

[SBF12345]

I am using the line below to determine characteristic qualities of a set of values. How is this being read? I would like for the test to meet the first part of the test and at least one of the second characteristics defined by the OR statement and contained within parenthesis.

If Cells(kk, 3) < Cells(hh, 3) And (StartDate2 <= StartDate1 <= EndDate2 Or StartDate2 <= EndDate1 <= EndDate2) Then

 

[mole999]

i cant test this against data but something like

=If(AND(cells(kk,3)<cells(hh,3),OR(startdate2 <=startdate1,startdate1 <=endate2,enddat2

so AND checks the first statement (cells(kk,3)<cells(hh,3), against the second. The OR(startdate2 <=startdate1,startdate1 <=endate2,enddat2 looks at the alternate options

this is not the answer, just something to work with

 

[rlv01]

You are trying to evaluate a boolean expression of the form

Condition1 AND (Condition2 OR condition 2)

Where

Condition1 = Cells(kk, 3) < Cells(hh, 3)
Condition2 = StartDate2 <= StartDate1 <= EndDate2
Condition3 = StartDate2 <= EndDate1 <= EndDate2

The problem is that you are constructing condition2 and condition3, assuming that VBA will chain boolean expressions like C/C++ will, and in my experience, VBA dislikes this. You need to break up condition2 & 3 so that you are only testing two elements at a time, e.g. Condition2 = (StartDate2 <= StartDate1) OR <= (StartDate1 <= EndDate2)

 

[SBF12345]

I wrote it to read as below, but am receiving a "must be first statement on the line" compile error on the line directly below

Else If StartDate2 <= EndDate1 And EndDate1 <= EndDate2 AND Cells(kk,3) < Cells(hh,3) Then

If StartDate2 <= StartDate1 And StartDate1 <= EndDate2 And Cells(kk, 3) < Cells(hh, 3) Then        
            Cells(hh, 3).Interior.ColorIndex = 5
        
            Else If StartDate2 <= EndDate1 And EndDate1 <= EndDate2 AND Cells(kk,3) < Cells(hh,3) Then
        
            Cells(hh, 3).Interior.ColorIndex = 5
            
        End If

 

[SBF12345]

I broke the two statements into two separate IF statements and it seems to be working. Thanks for your help!

 

[MARK858]

Else If should be one word i.e. ElseIf