IF AND Statement Question

[yzhang316]

Hi, 

How to translate the following excel formula into Alteryx?

=IF(AND(A1<=0.001,A1>=-0.001),0,FALSE)

Thanks!

[patrick_digan · Accepted 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. 

[MarqueeCrew · Accepted solution]

@yzhang316,

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.

[yzhang316]

The formula worked!

[yzhang316]

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.