How to set prices over percentage

  • Hello,


    I would like to allocate my budget (B11 in the sample) through items to be sold. I am stuck with fixed percentages given by product seller; a price to be offered cannot be out of minimum and maximum percentage values. My percentage will be set according to this formula: Price (B7, for instance) / Total Budget. My boss wants to arrange ranges freely in accordance with minimum-maximum percentage rates and she wants to know if a value entered into any item price, how much percent it is to minimum and maximum percentages and what price should we put into the cell in order to stay between fixed percentage values as minimum and maximum. Although it seems that like simple, for me, it is an issue to overcome. Any help will be appreciated.

    Files

    • Sample.xlsx

      (9.6 kB, downloaded 13 times, last: )

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke
    [/SIZE]