Got stuck in writing the syntax for IF formula

[NimishK]

Hello
=IF(BE3<$A$1,BF3,0)+IF(BJ3<$A$1,BK3,0)+IF(BO3<$B$2,BP3,0)+IF(BT3<$A$1,BU3,0)+IF(BY3<$A$1,BZ3,0)
Got stuck in writing the syntax for above with IF formula

curRow = 3
ws.Cells(curRow, 83).Formula = "=IF(BE" & curRow & "<a1," &="" "bf,"="" "0)"

Thanks
NimishK</a1,">

 

[mikerickson]

Recording a macro of me entering the formula into a cell is the way that I get proper syntax for that formula.

 

[NimishK]

Thank you sir, For the Hint
Had to struggle a bit because of commas or seperators.
So far so good
<a1" &="" ",bf"="" currow="" ",0)"="" _
<a1" &="" ",bk"="" currow="" ",0)"="" _
<a1" &="" ",bp"="" currow="" ",0)"="" _
<a1" &="" ",bu"="" currow="" ",0)"="" _
<a1" &="" ",bz"="" currow="" ",0)"
<a1" &="" ",bf"="" currow="" ",0)"="" _
<a1" &="" ",bk"="" currow="" ",0)"="" _
<a1" &="" ",bp"="" currow="" ",0)"="" _
<a1" &="" ",bu"="" currow="" ",0)"="" _
<a1" &="" ",bz"="" currow="" ",0)"
<a1" &="" ",bf"="" currow="" ",0)"="" "+if(bj"="" "<a1"="" ",bk"="" "+if(bo"="" ",bp"="" "+if(bt"="" ",bu"="" "+if(by"="" ",bz"="" ",0)"
<a1" &="" ",bf"="" currow="" ",0)"="" "+if(bj"="" "<a1"="" ",bk"=""
<a1" &="" ",bf"="" currow="" ",0)"="" "+if(bj"="" "<a1"="" ",bk"="" ",0)"
<a1" &="" ",bf"="" currow="" ",0)"=""

ws.Cells(curRow, 83).Formula = "=IF(BE" & curRow & "<A1" & ",BF" & curRow & ",0)"<a1" &="" ",bf"="" currow="" ",0)"

Except for the Abosolute refernce before A1 i.e "<$A$1"</a1"></a1"></a1"></a1"></a1"></a1"></a1"></a1"></a1"></a1"></a1"></a1"></a1"></a1"></a1">

 

[NimishK]

ws.Cells(curRow, 83).Formula = "=IF(BE" & curRow & "<a1" &="" ",bf"="" currow="" ",0)"<a1"="" ",0)"

cant submit the full code som errors came when copying the code
ws.Cells(curRow, 83).Formula = "=IF(BE" & curRow & "<A1" & ",BF" & curRow & ",0)"____________</a1">

 

[Fluff]

@NimishK
You need to add spaces around the < & > signs, otherwise the software thinks that you are posting HTML code.

 

[Norie]

Try this.

Cells(curRow, 83).FormulaR1C1 = "=IF(R1C1>RC[-26],RC[-25],0)+IF(R1C1>RC[-21],RC[-20],0)+IF(R2C2>RC[-16],RC[-15],0)+IF(R1C1>RC[-11],RC[-10],0)+IF(R1C1>RC[-6],RC[-5],0)"

 

[NimishK]

Thankx Fluff and Norie