Deducing maximum for variable where condition is true
I have a complex pricing model example here but what I want to do is calculate one of the maximum for one of the variables (cost) where the Selling price = Target price. The issue is complicated by the fact that part of the selling price calculation is the cost.
I think this may not be possible but I feel obliged to ask is there any way of incrementing through the cost variable until Target Price = Selling Price then presenting this value in the straight table?
