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.

I've found the best formula from this site. Thank you for sharing this, and let me tell you something: we just had the greatest sale of our business lunch, so check out these special forces jackets from our forces jackets firm, which is the best in the United States.