Error in the formula

I’m trying to write the following formula in Excel in the activity Write Cell.
“=IF(G2=“SA”,0,(L2+AA2))”
It is copied from Excel and works for sure.
But the robot gives an error. Please tell me what is the problem?
formula

Hi,

Please use the formula like below.

“IF(G2=”+CHR(34)+“SA”+CHR(34)+",0,(L2+AA2))"

CHR(34) represent double quote.

It will not throw any error. Thanks

1 Like

Thank you very much, it works

1 Like

Your most welcome.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.