IFF Statement with AND OR

Question

Need a little help converting a Excel Formula to an Alteryx Expression.

The formula from Excel.

=IF(AND(CM3<>TRUE,OR(CD3,CK3)),TRUE,FALSE)

My interpretation is

IIf ([Auto Exclude]!='True' AND [No Consumption last 24 months] OR [<$10K],'True','False'

I need a little guidance on the syntax... or if the formula for alteryx needs to broken up into multiple if statements than can work too. Just a little stuck here.

Thank you.

binu_acs · Accepted Answer

@Iamironman

IIf([Auto Exclude]!='True' AND ([No Consumption last 24 months] = 'True' OR [<$10K] = 'True'),'True','False')

binu_acs · Accepted Answer

@Iamironman Can you check your data type of the field [Auto Exclude]? also if possible can you screen shot your formula tool with data?