convert excel formula into Alteryx formula

[AvinashBhawsar]

Hi All,

I hope everyone is doing well. can anyone help me out to convert the below formulas into alteryx compatible.

=IF(D2="","",IF(OR(W2="Reconciled",W2="Timing Delays"),0,IF(AND(Q2="Same",R2>0),R2+1,IF(Q2="New",1,"ERROR"))))

D2 represent the column :- SellerLoanNum

W2 represent the column :- NOTES

Q2 represent the column :- Compare Notes)

R2 represent the column :- Prior Age

 =IF(A2="PASTE DATA HERE","",IF(ISNA(IF(P2=U2,"Same","New")),"",IF(P2=U2,"Same","New")))

A2 represent the column :- SellerId

P2 represent the column :- Prior Day Notes

U2 represent the column :- Breaks Check

Thanks for taking out time to read 

[AvinashBhawsar]

@atcodedog05 @Luke_C  you guys are awesome.. it worked successfully, there was an issue with the data type which I had to changed. thanks a lot and thanks for teaching me something new :)