IF THEN Statement

[AgiGovind]

Hello - 

I'm trying to write the following formula in Alteryx; wondering if anyone could help:

if [difference] <=1 and [difference] >=-1 then "round off"

else " " endif

So any value between -1 to +1 should be commented as 'Round off' except 'zero' it should be blank.  

Output:

Difference	Comment
-0.36	Round off
-0.25	Round off
0
0
0.45	Round off

[A1exW · Accepted solution]

IF [Difference] = 0 then ""
elseif [Difference]<=1 and [Difference] >=-1 THEN "round off"
ELSE "" ENDIF

[nagakavyasri]

if [difference] <=1 and [difference] >=-1 and [difference]!=0 then "round off" else " " endif

[apathetichell · Accepted solution]

tbh --- you're pretty close here --- probably good practice for you to just add another formula tool and force convert 0 from round off to '' 

I'd use --> if abs([difference])>0 and abs([difference])<=1 then "round off" else "" endif