Hi,

Firstly it's not an array formula and so no need for FormulaArray and second
double up on the quotes to solve your problem

Range("A1").Formula = "=if(B1=""Loan"",D1,0)"

Mike

"diepvic" wrote:

Hi,
I've got a macro code as below:
Range("A1").FormulaArray = _
"=if(B1="Loan",D1,0)"

And it causes a compile error. How should I fix it if I want to keep the
text Loan in my formula.

Thanks so much