Hello Knime Fans,

I am trying to figth with one XLS table and one simple math rule. The idea is:

1. I have a xls table with 3 columns: Product Number | Rating | Scores

For example: 1 | 10 | 40

2 | 12 | 80

3 | 15 | 70

2. This table is cnaging everyday, so I want to check it and IF the Scores are over 60, the Rating of the Product have to be increased with 33%.

IF Scores(Product1) > 60

THEN Rating(Product1) = Rating(Product1) + Rating(Product1)*33/100

3. Update the new result in a table.

I tried with Math Formula but I couldn`t find If statement with an action, I found If statement with writing 1 or 0 in a new column.

How can I make it in Knime?

Can you help in this, please?

Regards,

Vlady