IF AND

[brij]

okay just tried case and that works

case
when "Billings$"<"BillingsCost$" then
"Billings$"-"BillingsCost$"
else 0
end

However IF has some bug in alteryx maybe .

Thanks for all the support so far.

BR

Brij

[papalow]

Thanks for posting this, can you use && in a regular IF THEN ELSE ?

[Matt_Sinker]

Hi There,

Taking the same logic, how would I go about writing a formula with 3 conditions.

I am trying to replicate an excel formula which would read:

=IF(AND([X]="Y",[X]="N",[X]="N"),"Y","N")

Tried using the IF ELSEIF function but this isn't right, any thoughts?

[Matt_Sinker]

=IF(AND([X]="Y",[X1]="N",[X2]="N"),"Y","N") - would make more sense, apologies.

[Matt_Sinker]

Solved guys.

I didn't realise you could simply use AND in an IF THEN ELSE formula in Alteryx.

IF ([X]="Y" AND [X1]="N" AND [X2]="N") THEN "Y" ELSE "N" ENDIF - Worked.