Writing Conditional IF/OR/AND

Having trouble converting conditional excel formulas into Alteryx syntax. Essentially I want to create a statement which reads IF X OR Y is TRUE then YES else NO. Note X and Y are themselves conditional AND statements.

In excel this would read IF(OR(AND(Y="0", Balance1<>0),AND(Y="0",Balance2<>0)),"Yes","No").

Any help would be appreciated! For some reason this board is not allowing me to upload my workflow, but formula reads as below in current state.

ACBAL Conversion Design.yxmd

Tips and Tricks

Accepted answers

Garrett

IF ([PRODUCT] = "0" AND [AIR Balance] != 0) OR ([PRODUCT] = "0" AND [AIP Balance] != 0)

Then "Yes"

Else "No" EndIf

All comments

Garrett

IF ([PRODUCT] = "0" AND [AIR Balance] != 0) OR ([PRODUCT] = "0" AND [AIP Balance] != 0)

Then "Yes"

Else "No" EndIf

AlteryxUserFL

Hello,

Here is an example:

IF ([Incremental Change Flag] = "1" OR [Two Touch Flag] = "1" OR [Signature Amount Flag] = "1") And [Incremental Change (USD)] > 299999 THEN "SOX"
ELSEIF [Incremental Change (USD)] > 99999 THEN "Operational 100k"
ELSE "Other"
ENDIF

Here is your example:

IF ([y] = "0" and [Balance1] != "0") or ([y]="0" and [Balance1] != "0") then "YES" else "No" ENDIF

unknown

thanks that did it!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703