IF THEN Statement

Question

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:

DifferenceComment-0.36Round off-0.25Round off0 0 0.45Round off

A1exW · Accepted Answer

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

apathetichell · Accepted Answer

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