Hi all,

Can anyone help me with a workaround for this line of code?

Range("r2").Formula = "=IF(Q2="w",(P2*(E2-1)*0.95),-P2)"

When the compiler gets to the "w" part of the formula it's expecting "w" to
be a variable or something as it sees me as closing this part "=IF(Q2="

I'm sure there's a simple explanation that I'm overlooking?

Any help or pointers appreciated

Ron