How to Set IF Statement in Assign Activity?

[ARahman (Md. Abdur Rahman)]

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

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

[Sasi.lalo (Sasikumar)]

Hi @ARahman,

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

[Yoichi]

Hi,

Can you try the following?

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

Regards,

[hacky (NotHacker)]

@ARahman

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

This works.

[ImPratham45 (Prathamesh Patil)]

Try This

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

[ARahman (Md. Abdur Rahman)]

Thanks to Everyone & @Yoichi your formula working properly.

[ARahman (Md. Abdur Rahman)]

@ImPratham45… Thanks

[jothyprasanth.m (JothyPrasanth)]

@ARahman

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

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

Regards
JothyPrasanth M