IF And Statements

[JamesBond]

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")))

[danilang]

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

[Qiu · Accepted solution]

@JamesBond 
Hope I get your correct.

[JamesBond]

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

[JamesBond]

Thank you very much.

Ryan

[JamesBond]

n

[danilang]

Hi @JamesBond 

Can you provide some sample data and what your expected outcome is?  It would limit the amount of back and forth required to come up with a final solution.  

Thanks

Dan

[JamesBond]

Dan - I was able to get it working based upon what Qui posted earlier. 

Appreciate the patience and help. 

Ryan