R1C1 syntax

Can someone please help me convert and understand the below formula in R1C1, I am struggling a bit with this. Thank you.

 Const myEpilepsy As String = "=IF(SUMPRODUCT(--(Panel!$B$2:$B$6713=$Q$5),--(Panel!$C$2:$C$6713<=$R$5),--(Panel!$D$2:$D$6713>$R$5)),VLOOKUP($R$5,Panel!$C$2:$E$6713,3,1),""No"")"

Here is my attempt:

 ActiveCell.FormulaR1C1 = _
Const myEpilepsy As String = "=IF(SUMPRODUCT(--(Panel!$R[2]$R[2]:$R[6713]$R[2]=Annovar!$R[5]$C[17]),--(Panel!$R[2]$C[3]:$R[6713]$C[3]<=Annovar!$R[5]$C[18]),--(Panel!$R[2]$C[4]:$R[6713]$C[4]>Annovar!$R[5]$C[18])),VLOOKUP(Annovar!$R[5]$C[18],Panel!$R[2]$C[3]:$R[6713]$C[5],3,1),""No"")"