Modify Excel formula into Alteryx format

Question

Hi

I have this formula in excel " =IF(T2="No",IF((S2/100)-O2<0,"Below","Above"),"NA") "

How can I modify this in alteryx formula format?

FYI

T is column which as Yes and No as in the row.

Formula is saying check col T and if we have NO then check Col S and divide it by 100 subtract by col O if is less that 0 then print below else print Above.

If both condition doesn't satisfy print NA for all the yes in col T.

Please help

binu_acs · Answer

@sagargaryali01

IF [T2] = "No" THEN 
    IF ([S2] / 100) - [O2] < 0 THEN 
        "Below" 
    ELSE 
        "Above" 
    ENDIF 
ELSE 
    "NA" 
ENDIF

aatalai · Answer

@sagargaryali01 try this

If [Field T] ="No" and  ( ([Field S]/100)  - [Feild O] )< 0 then "Below"

elseif [Field T] ="No" and  ( ([Field S]/100)  - [Feild O] ) >= 0 then "Above"

else "NA"

Endif

but agree with @Qiu a sample would help

Qiu · Answer

@sagargaryali01 
Maybe you can provide sample input data and desired output?