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.