Conditional Insert more than one string

IvanMtz

Hello Alteryx Community 

I have a problem with conditionals I'm trying to do a formula but it doesn't do what I need it to do and I'm thinking that my syntax is wrong here it is

IF [Expense Type]=='Hotel' and [Expense Area Name]IN('Phoenix','Scottsdale','Monterey','Napa') and [Overage]=='Yes' THEN ([Reimbursement Amount] - 195) ELSE 0 ENDIF

But in the column, it doesn't do the subtraction 

Could you please help me and is correct to use IN to search for more than one string? 

Thank you for all your help

atcodedog05

Hi @IvanMtz 

Here is an example your formula is working. 

Workflow:

Please check your incoming data make sure they are same dont have spaces.

Hope this helps : )

Reimburse.yxmd