Hello Kumaran,

There does not exist a built-in way to copy a formula to each row of a Worksheet with a cell increment, but this behavior could be easily achieved using a loop. For example, the following code would achieve one of your “IF” formulas for the first 1046 cells:

        Dim workbook As Workbook = New Workbook(WorkbookFormat.Excel2007)
        Dim sheet As Worksheet = workbook.Sheets.Add("Sheet1", SheetType.Worksheet)

        For i As Integer = 1 To 1046 - 1
            Dim cell As WorksheetCell = sheet.GetCell("K" & i.ToString())
            Dim formulaString As String = "=IF(D" & i.ToString() & "=" & """96""" & "," & """""" & ",A" & i.ToString() & ")"
            cell.ApplyFormula(formulaString)
        Next

I hope this helps you. Please let me know if you have any other questions or concerns on this matter.

Interested in flirting with attractive girls? Hiring Independent Delhi Escorts might just be what's needed. These girls make great partners during bed or other sensual activities. These gorgeous women can accompany you on visits to restaurants, discos, pubs, and travel companions during an extended vacation. Model Delhi Escort Service are some of the sexiest women around. With stunning eyes and delicate lips, model escorts provide excellent services from Escort Service Delhi's beautiful girls, ensuring clients enjoy themselves and offering massages or sexual pleasure services when requested.