Error in the formula

Help Robot
,
1

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

if
if706×294 6.1 KB

2

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

2 Likes
3

Thank you very much, it works

1 Like
4

Your most welcome.

5

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