0 Replies Latest reply: Sep 4, 2012 6:31 AM by Richard Beeston RSS

    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?