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