How do I add a counter indx to my formula to continue to move down the column?

[Rcflife2335]

Sub MATH ( )


Dim LastROW As Integer Dim shODS As Worksheet


LastROW = Range ("K" & Rows. Count) . End (xlUp) . Row


Set shODS = ThisWorkbook-Worksheets ("ODS")


LastROW = shODS. Cells (Rows. Count, 1) . End (x1Up) .Row

For indx = 2 To LastROW

ShODS. Range ("K" & indx) .Formula = "=IFS (I = 0," & indx & Chr (34) & Chr (34) & ",H > I , "
indx & Chr (34) & "YES" & Chr (34) & ",1 = 1," & Chr (34) & "NO" & Chr (34) & ") "


Next


End Sub

 

[rlv01]

Can you post an example of what your formula looks like for cells in row 1 (e.g. H1, I1, K1, L1)?