Help with Formula

Question

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,""))

binu_acs · Answer

@djm another option

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

Qiu · Answer

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

20220120-djm.yxmd

Qiu · Answer

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