SYNTAX ERROR on cells.Formula

[jarvisaurus]

I am getting a syntax error on the following line:

cells(i, "AI").Formula = "=(4917.56 * cells(i,"X").value + 424) * 0.93"

I had .value before but I need to show the actual formula. The cells(i,"X").Value should be the value of the corresponding row, column.

Any help is greatly appreciated.

Thanks

 

[Norie]

Do you want to include the address or value of Cells(i, "X")?

Or do you actually want to put the text cells(i, "X").value in the formula?

 

[jarvisaurus]

Oh sorry, the address like X2,X3,X4, etc where X is the column. Thanks.

 

[Oaktree]

Say i = 5 and the value in X5 is 20

If you want AI5's formula to be =(4917.56 *20+ 424) * 0.93, use

Cells(i, "AI").Formula = "=(4917.56 *" & Cells(i, "X").Value & "+ 424) * 0.93"

If instead you want AI5's formula to be =(4917.56 * X5+ 424) * 0.93, use

Cells(i, "AI").Formula = "=(4917.56 * X" & i & "+ 424) * 0.93"

Just depends on whether you want the hardcoded value from X5 or the reference to X5 in your formula.

 

[jarvisaurus]

Thank you! =)