Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

IF AND Statement Question

8 - Asteroid

Hi, 

 

How to translate the following excel formula into Alteryx?

 

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

 

Thanks!

16 - Nebula
16 - Nebula

@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. 

Alteryx Certified Partner
Alteryx Certified Partner

@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.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
8 - Asteroid

The formula worked!

8 - Asteroid

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. 

Labels