Help Translating Excel Formula to Alteryx

[djm]

Hello All,

I have the below excel formula that I am trying to use in Alteryx. Would be greatly appreciated if someone can help with this, so that I can use the exact same formula but for Alteryx:

=IF(AND(OR(AE2<>"England",NP2<>0),D2<>"Equity",T2>0,OR(D2<>"Options",A2="Pound")),T2,"")

[saveeshkumar]

Hi djm,

Please find the below formula..

IF
(
([A2]!="England" or [N2] != 0) AND
[D2]!="Equity" AND
[T2]>0 AND
([D2] !="Options" or [A2]!="Pound")
)
THEN [T2]
ELSE ""
ENDIF

Thanks