Using the IF formula in Alteryx

[HannahSwain]

Hi all,

I am relatively new to using Alteryx and I am attempting to write a formula where if either/both column A and B contains 'Exceeds' then I require a 'Yes' otherwise I need the formula to show as 'No'.

Any assistance is greatly appreciate!

Many thanks,

Hannah

[afv2688 · Accepted solution]

Hello @HannahSwain ,

The formula would be like this

IF [A] = "Exceeds" OR [B] = "Exceeds" THEN "YES" ELSE "NO" ENDIF

P.d: Welcome to the community :)

Cheers!

[Loic]

Look at the attached workflow.

I created 2 formulas. One is a Boolean (True/False) the other is a string that returns Yes/No. It uses contains (vs. perfect equal sign) and it takes into account that the case could be different.

Match Boolean:

Contains(LowerCase([A]),"exceeds") OR Contains(LowerCase([B]),"exceeds")

Match Yes/No:

IF Contains(LowerCase([A]),"exceeds") OR Contains(LowerCase([B]),"exceeds") then "Yes"
ELSE "No"
ENDIF

[vplante]

Works fine, thanks !

[nowacki0727]

Hello,  I'm hoping you can assist me as well.

I am trying to come up with a formula which basically says:

If Item description contains brochure and State does not equal GA then change Value to 0.00 otherwise leave it alone

Any assistance is appreciated 🙂