To many IF conditions in excel to Alteryx

[sriniprad08]

Hi Team,

Hope you are well.

I need help. I have this excel function which i need to replicate into alteryx. Can you please help?

thanks

IF(B3="BELOW THRESHOLD STABLE",0,IF(B3="ABOVE THRESHOLD STABLE",1,IF(B3="ABOVE THRESHOLD FLAG",2,0)))+IF(C3="BELOW THRESHOLD STABLE",0,IF(C3="ABOVE THRESHOLD STABLE",1,IF(C3="ABOVE THRESHOLD FLAG",2,0)))+IF(D3="BELOW THRESHOLD STABLE",0,IF(D3="ABOVE THRESHOLD STABLE",1,IF(D3="ABOVE THRESHOLD FLAG",2,0)))+IF(E3="BELOW THRESHOLD STABLE",0,IF(E3="ABOVE THRESHOLD STABLE",1,IF(E3="ABOVE THRESHOLD FLAG",2,0)))+IF(F3="BELOW THRESHOLD STABLE",0,IF(F3="ABOVE THRESHOLD STABLE",1,IF(F3="ABOVE THRESHOLD FLAG",2,0)))+IF(G3="BELOW THRESHOLD STABLE",0,IF(G3="ABOVE THRESHOLD STABLE",1,IF(G3="ABOVE THRESHOLD FLAG",2,0)))+IF(H3="BELOW THRESHOLD STABLE",0,IF(H3="ABOVE THRESHOLD STABLE",1,IF(H3="ABOVE THRESHOLD FLAG",2,0)))

I would like to create the column I ,"Weighted Score" in the below excel file.

Please find attached,

Thanks,

[atcodedog05]

Hi @sriniprad08 

You can transpose it, apply the condition and summation it. Like below

Hope this helps : )

[Christina_H]

I've done basically the same as @atcodedog05 but with a lookup table for the values instead of the formula

[sriniprad08]

Hi @atcodedog05 ,

Perfect. Thank you so much is it also possible to color the fields like a heat map for e.g

Wherever its Below Threshold then it should be colored Green. etc.

Please let me know 

thanks,

[sriniprad08]

Hi @Christina_H ,

Thank you so much 🙂 . Very helpful.

Cheers

[Christina_H · Accepted solution]

@sriniprad08 To get background colors you'll need to use a table tool with column rules, see attached.  I've set conditions on the first two columns, they will need adding to the others too.

[atcodedog05 · Accepted solution]

Hi @sriniprad08 

Here is my take on it by setting the column rule 

Workflow:

Hope this helps : )

[sriniprad08]

Hi @Christina_H ,

Thank you . Amazing. I was about to paste this question. How to set the rule please?

Thanks,

Sri

[sriniprad08]

Hi @atcodedog05 ,

Amazing too. Thank you very much.

Cheers,

Sri

[sriniprad08]

Hi @atcodedog05 ,

Not sure why its not showing me the option to edit. Please let me know .

thanks