Design Excel formula with a workflow

[carrera]

Hello all,

I am trying to design an Excel formula with an Alteryx workflow:

I already have column D imported in Alteryx. I thought about the Multi-Row tool, which might be useful to work with. But I have only used the normal formula tool so far with very simple formulas. I am struggling with this one.

Does anyone know how to solve this with Alteryx?

[Pang_Hee_Choy · Accepted solution]

for most of the tool, it have an option to open example, you may try to open it. 

you can manipulate the config to understand how it work.

for your question, in multiple row tool, just simple replace

D49 with [D] and D48 with [Row-1:D] and E48 with [Row-1:E]

maybe you can explore formula, SWITCH