How to translate a Excel formula to a Alteryx formula?

[rmartinez4]

Hi All,  

Not sure if it possible to translate this Excel formula to Alteryx? Any field below that has Date is a data type of date everything else is a string. 

Excel Formula:

=IF(AND([@[Venus -Date last seen]]="",[@[Memo]]="",OR([@[World - Last logon Date]]="",[@[World - Last logon Date]]<TODAY()-60),OR([@[Mars - Last Seen Date]]="",([@[Mars - Last Seen Date]]<TODAY()-15))),"Drop It","")

My Alteryx translation: Not sure if it's correct.

If IsEmpty([Venus -Date last seen]) and IsEmpty([Memo]) or IsEmpty([World - Last logon Date]) and [World - Last logon Date] > DateTimeAdd(DateTimeToday(),-60,"days") or IsEmpty([Mars - Last Seen Date]) and [Mars - Last Seen Date] > DateTimeAdd(DateTimeToday(),-15,"days") then "Drop It" else "" endif

Thank you for all your help.

[joelmiller66]

@rmartinez4 Do you have a sample dataset with the fields and desired output?

[binu_acs]

@rmartinez4 Your Alteryx formula is correct only i changed the > to < as per the excel formula

If IsEmpty([Venus -Date last seen]) and IsEmpty([Memo])
	or 
IsEmpty([World - Last logon Date]) and [World - Last logon Date] < DateTimeAdd(DateTimeToday(),-60,"days") 
	or
IsEmpty([Mars - Last Seen Date]) and [Mars - Last Seen Date] < DateTimeAdd(DateTimeToday(),-15,"days") then "Drop It" 
else "" 
endif