How to Set IF Statement in Assign Activity?

How to Set this below formula in Assign activity… shown error for using this double quotation

“=If(B2<40,“FAIL”,“PASS”)”

Hi @ARahman,

Please use statement like below:
IF(B2<40,“FAIL”,“PASS”)

1 Like

Hi,

Can you try the following?

"=If(B2<40,""FAIL"",""PASS"")"

Regards,

3 Likes

@ARahman

Please use statement like below:
IF(B2<40,“FAIL”,“PASS”)

This works.

2 Likes

Try This

“=If(B2<40,”+“”“”+“FAIL”+“”“”+“,”+“”“”+“PASS”+“”“”+“)”

1 Like

Thanks to Everyone & @Yoichi your formula working properly.

1 Like

@ImPratham45… Thanks

You can try this chr(34)+“=If(B2<40,”+chr(34)+“FAIL”+chr(34)+“,”+chr(34)+“PASS”+chr(34)+“)”+chr(34)

Regards
JothyPrasanth M

1 Like

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