title: Openpyxl: filling column with formulas
body: <p>I am trying to copy this formula =IFERROR(IF(MATCH(D2,Control!$J$3:$J$914,0),&quot;YES&quot;,),&quot;NO&quot;) that starts in row 2, but column BJ in excel.</p>
  <p>I want to make this formula go to the last row which is 31693</p>
  <pre><code>for row, cellObj in enumerate(list(sheet2.columns)[62]):
  if row != 0:
      n = '=IFERROR(IF(MATCH(D%d,Control!$J$3:$J$914,0),&quot;YES&quot;,),&quot;NO&quot;)' % (row+1, row+1)
      cellObj.value = n
  </code></pre>
  <p>when I ran this code I got an error message saying not all arguments converted during string formatting. Not sure what to fix</p>