Hi,
How to translate the following excel formula into Alteryx?
=IF(AND(A1<=0.001,A1>=-0.001),0,FALSE)
Thanks!
Solved! Go to Solution.
@yzhang316 try this in a formula tool:
IIF(A1<=0.001 and A1>=-0.001,"0","FALSE")
where A1 refers to the Field you're looking at.
IF [A1]<=0.001 AND [A1] >= -0.001 THEN "0" ELSE "FALSE" ENDIF
I'm puzzled by why they would want 0 and "False" as the results. I turned everything to a string.
The formula worked!
I had to make sure 0 is the True, while else is false. You're correct that I had to change the string in order to proceed into the next part.