Help with Formula

[djm]

Hi All,

I am trying to use the following excel formula in alteryx but have been unsuccessful in doing so. If someone could it would be much appreciated

Below is the formula in excel format. Please let me know what this would be in alteryx

=(IF(AND(OR(AE1<>"Canada",NP1<>0),D1<>"Stocks",D1<>"Bonds",T1>0),T1,""))

[Qiu]

@djm 
Can you provide some data sample with your desired output?

[Qiu]

@djm 
I hope this is what you need. 
I have to mock some data. 😀

[binuacs]

@djm another option 

IIF(([AE1] != "Canada" OR [NP1] != 0) AND [D1] NOT IN ("Stocks","Bonds") AND [T1] > 0 , [T1], Null())