Automatically Adjusting Cell Values

**Chloed** · 07-13-2009, 07:33 PM

Hi

I have an excel table which is used to develop a pricing schedule for a product. It has a number of dynamic variables (percentages) which I would like to balance out.

What I want to do is when I put in a new manufacturing price that the two variable percentages balance out so that the distributor margin = 20% and the wholesale margin is what is left over. At the moment I am having to manually change the wholesale margin so that the distributor margin = 20% and would love to have this happen automatically.

Cheers

**Paul** · 07-13-2009, 09:59 PM

Hi Chloed, welcome to the forum.

Would you mind attaching an example spreadsheet with some sample data, and show us where you would like the results (and the results you would expect from the sample data)?

**Chloed** · 07-13-2009, 11:41 PM

Hi

Thanks for your quick reply.

Attached is an example of what I am talking about. I am wanting the yellow margin figure to automatically update with any changes to the manufacturing cost so that the model balances.

I think that it is probably pretty basic but I just cant seem to work it out!

Thanks so much

Chloe