VBA If...Else If unable to return value to cells met condition

[Ann Ooi]

Hi, I have the data sheet "DataCompile", which I tried to use if...else if to return value into column M, if the criteria in column N is met. However, no matter how I change the coding, it will not return other value, and only return the largest value, which is "60%><=100% Yield".
What should I do to rectify the coding below, so that it can populate every cell with correct value, that is meeting the criteria?

Sub FillIF()

Application.ScreenUpdating = False

Dim w2 As Worksheet
Dim LastRow As Long
Dim StartRow As Long

Set w2 = Sheets("DataCompile")

On Error Resume Next

LastRow = w2.Cells(w2.Rows.Count, 1).End(xlUp).Row
StartRow = w2.Cells(w2.Rows.Count, 14).End(xlUp).Row + 1

Dim i As Long
Dim Yield As Long
Dim Result As String

For i = StartRow To LastRow
Yield = w2.Range("M" & i).Value
      
If Yield > 0.6 And Yield <= 1 Then
    Result = "60%><=100% Yield"
ElseIf Yield > 0.3 And Yield <= 0.6 Then
    Result = "=<60% Yield"
Else
    Result = "=<30% Yield"
End If
  w2.Range("N" & i).Value = Result
 
Next

Application.ScreenUpdating = True

End Sub

 

[Ann Ooi]

Result = "'60%><=100% Yield"

Hi eduzs, finally, it works. It's real challenge going through all these coding. It kills lots of my cells, just to solve one minor dot.

Hi all, Thanks a lot. you are great. it works now!

 

[Ann Ooi]

Not quite, it needs to be inside the double quotes to that is evaluated as a text comment when it is passed to the sheet rather than being a comment in vba.

I've added it in red below to try and make it stand out a little better. You shouldn't need it in this one, although it will do no harm, but the other 2 definitely need it.

Result = "'60%><=100% Yield"

Hi Jason, yes, finally sorted out the issue, and thank you so much.

 

[eduzs]

Place a breakpoint at this line
"If Yield > 0.6 And Yield <= 1 Then"
run the code for that row and see what's "Yield" value.

 

[Ann Ooi]

Place a breakpoint at this line
"If Yield > 0.6 And Yield <= 1 Then"
run the code for that row and see what's "Yield" value.

Putting the breakpoint and It's working fine now.