Math Formula if Statement

[aworker]

Hi @PXP_Mo and welcome to the KNIME forum community,

Complementary to @ipazin link, please find below other links sorted by importance that might answer your question:

Different Math Formula for Different Row in One Same Column

Hi @rizky_kahfie There is an If-Condition “if (cond, trueval, falseval)” instruction in the -math Formula- node which allows to do a conditional operation: [image] The instruction to write in your case would be: $Column A$ * if( $$ROWINDEX$$ < 10, 2, 3) Hope this helps. Regards Ael

Divide by a Row value and Multiply by a constant

Hi @kanishka271 Following @Daniel_Weikert’s trick, you will find below a solution that takes into account your other requirements too: [image] The extra added trick here is to use a “if-then-else” condition to avoid dividing the last row too: if($$ROWINDEX$$ + 1 < $$ROWCOUNT$$, 100 * $$CURRENT_COLUMN$$ / COL_MAX($$CURRENT_COLUMN$$), $$CURRENT_COLUMN$$) Hope it helps. Best Ael

Convert negative values to positive and positive to negative

Hi @tdewagner & welcome to the KNIME community I guess the difficulty here comes from the list of proposed functions in the -Math Formula- node which does not include the basic mathematical operators “+,-,*,/”. The -Math Formula- node allows writing a mathematical formula as a combination of functions and basic mathematical operations. Parenthesis “(,)” to prioritize operations are also allowed. As explained in the help, one can also deal with NaN values (or missing values) with the following …

Hope it helps.

Best,
Ael