Writing Conditional IF/OR/AND

[Inactive User]

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.

[Garrett · Accepted solution]

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

[Inactive User]

thanks that did it!