Excel Formula in Column Expressions

This workflow demonstrates how to transform Excel formula which is using values from different rows and intermediate results in subsequent cells with Column Expressions node. Considering this is done based on group two solutions are given. First one is by using Group Loop where in each iteration same is applied inside Column Expressions while in second solution only Column Expressions is used and group logic is integrated inside. Both solutions are based on JavaScript Switch statement and rely on simulating global variables inside Column Expressions node.

External resources

• Global variables inside Column Expressions
• JavaScript Switch Statement
• Forum Topic