If condition

Question

Hi team,

I am receiving an error while applying if formula. I want if my reason column is = ACCEPTED, Offered, Permit, Asked, Given, shared, added, Taken then amt column should be '0' else should remain the same.

PFA data and workflow

Thanks,

Mohamamd Mustkeem

New Workflow5.yxmd

Reason.xlsx

Emil_Kos · Accepted Answer

Hi @mmustkee,

I have updated your workflow.

I also made some changes in the formula to make it cleaner:

if [Reason] IN ('ACCEPTED' ,'Offered','Permit','Asked') THEN 0 else [Amt] ENDIF

Assaf_m · Accepted Answer

Hi @mmustkee

Check attached solution

let me know if it works for you