table.ods (13.7 KB)

The table is used for calculation. Column A is the selling price, column B is the discount, column C is the price - discount x length.

I am looking for the highest price per meter including any discount. This works as long as there is no discount. But how can you use max if it gets a possible discount?

I had the idea combine max with if but this will not work.

Would be nice someone had an idea.

Silvio