I am trying to insert IF formula from VBA to excel sheet but i am facing compile error : Expected End of statement " Error. please advise.
Thanks in advance.
Here is code:
Sub frm()
Sheet13.Range("T2:T15001").Formula =
"=IF(AND(E2=""N/A"",F2="",I2="",J2="",M2="",O2=""N/A""),"",IF(N2>FocalDate,CONCATENATE(I2,"" Record Date Out of Focal Date""),IF(R2=""No"",CONCATENATE(TRIM(PROPER(CompanyName)),"" record date "",TEXT($N$2:$N$15001,""mm/dd/yy""),"", payable "",TEXT(PostedDate,""mm/dd/yy""),"" but not yet posted""),IF(AND(P2>0,Q2>0),CONCATENATE(TRIM(PROPER(CompanyName)),"" of "",DOLLAR(O2),"" record date "",TEXT($N$2:$N$15001,""mm/dd/yy""),"", posted "",TEXT(PostedDate,""mm/dd/yy""),"" Less: Foreign Tax of "",DOLLAR(Q2)," And ",""ADR Fee of "",DOLLAR(P2)),"
IF(P2>0",CONCATENATE(TRIM(PROPER(CompanyName)),"" of "",DOLLAR(O2),"" record date "",TEXT(RecordDate,""mm/dd/yy""),"", posted "",TEXT(PostedDate,""mm/dd/yy""),"" Less: ADR Fee of "",DOLLAR(P2)),IF(Q2>0,CONCATENATE(TRIM(PROPER(CompanyName)),"" of "",DOLLAR(O2),""record date "",TEXT($N$2:$N$15001,""mm/dd/yy""),"", posted "",TEXT(PostedDate,""mm/dd/yy""),"" Less: Foreign Tax of "",DOLLAR(Q2)),CONCATENATE(TRIM(PROPER(CompanyName)),"" record date "",TEXT($N$2:$N$15001,""mm/dd/yy""),"", posted "",TEXT(PostedDate,""mm/dd/yy""))))))))
End Sub
