if statement without an else using vba code, giving me a syntax error
<pre><code>Dim a As Long
a = range("A617:A737").Copy
s = range("A739:A" &amp; EndLine + 2).PasteSpecial

Dim FinalLine As Long
FinalLine = Cells(Rows.Count, "A").End(xlUp).Row
range("B739").AutoFill Destination:=range("B739:B" &amp; FinalLine - 2)

Cells(FinalLine + 10, 2).Formula = "= 5"

Cells("B" &amp; FinalLine + 3).FormulaArray = _
 "= Min(If(B739:B" &amp; FinalLine - 2 = FinalLine + 10 &amp; " , A$739:A$" &amp; EndLine + 2))"
</code></pre>

<p>The error is highlighting the comma after the 10.</p>