Hello -
I'm trying to write the following excel formula in Alteryx; wondering if anyone can help:
if(A2 = "ACQ", "",if(A2="P&G", "", if(A2 = "R&D", if(C2 <1,0,if(c2 >=1 and C2 <100),"Level1",if(c2>=101 and C2<200), "Level2",if(C2>=200, "Level3")))
@JamesBond Hope I get your correct.
Hi @JamesBond
Normally this process is very simple, just replacing each "if" with "iif". However, the formula that you've posted isn't valid in Excel either. As an example, your last if is missing the false statement. Did you make a transcription error?
Dan
Yes, transposition error on my end.
Trying to copy from one PC to another PC.
Let me try again:
=if(K2="R&D","",if(k2="P&G","",if(and(k2="ACQ",L2<1000),0,if(and(L2>=1000,L2<2200),"Level1,if(and(L2>=2200,L2<4000),"level2",if(L2>4000, "Level3")))
That's what I'm trying to make work. Thanks - Ryan
Thank you very much.
Ryan
n
