Need assistance in Formula

Learner09

Below is the excel formula

IF(AY3="SFW",IF(AD3<2500,"0-2500 EE",IF(AD3<5000,"2501-5000 EE",IF(AD3<10000,"5001-10k EE",IF(AD3<20000,"10001-20K EE",IF(AD3<50000,"20,001-50K EE",IF(AD3<100000,"50,001-100K EE","999,999 EE")))))),"")

I need to build the same formula in Alteryx. Please assist me

Example.xlsx

Jonathan-Sherman

Hi @Learner09,

I think this is what you're trying to achieve?

IF [Product LOB Code] = 'SFW'
THEN IF [License Count] < 2500 THEN '0-2500 EE'
ELSEIF [License Count] < 5000 THEN '2501-5000 EE'
ELSEIF [License Count] < 10000 THEN '5001-10k EE'
ELSEIF [License Count] < 20000 THEN '10001-20k EE'
ELSEIF [License Count] < 50000 THEN '20001-50k EE'
ELSEIF [License Count] < 100000 THEN '50001-100k EE'
ELSE '999999 EE'
ENDIF
ELSE ''
ENDIF

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20200513 - IFFormula.yxmd