Math Formula : 3 foumula in the same column IF

[Brain]

Hi
This is a simple workflow :
MATHS.xlsx (8.3 KB)
I want to create a column using this formula :
If T.E = HARD, New column = column TPS - 12
If T.E = MED, New column = column TPS - 16
If T.E = LOW, New column = column TPS - 18

My idea is to use row filter by TE and math formula and concatenate.
Is there a better solution?
Thanks
Br

[MartinDDDD]

Hey,

you can do this fairly quickly with Expressions Node.

I highly recommend the AI Assistant for these tasks:
Prompt:

Suggestions:

Result:

Workflow
mathformulalogic.knwf (81.1 KB)

[Brain]

I did not know this node.
Many thanks
Br

[SadatAnwar161]

Hi, Can any one help on how to apply IF conditions on more than one columns togehter?
Sadat

[rfeigel]

@MartinDDDD’s workflow does everything in one node and employs the growing power of the AI script builder. Regardless, here’s another way looping through the Column Expressions node.
mathformulalogic w Column Expressions.knwf (107.0 KB)

[rfeigel]

Move this to a new post and please provide more detail about what you’re trying to do.