complicated excel formula may need an algebra wiz

[pauld]

The worksheet is here, and the problem is described on the sheet.
http://kingfield.net/excel/formula-question.xlsx

In the simplest of terms, I am trying to find a formula which will allow usto adjust our profit margin either up or down. Lets say I want to increaseour margin by 3%.
Please see the worksheet on my website. It's so much better than trying to explain it.

Thank you, Paul


Cell B4 is calculated based on the % value entered into cell C2. I am looking for a formula to enter into Cell C1 which will return the percentage value that I would need to enter into cell C2 in order to achieve an increase or decrease of cell B4 by the amount shown in cell A1.

 

[shanermuls]

The worksheet is here, and the problem is described on the sheet.
http://kingfield.net/excel/formula-question.xlsx

In the simplest of terms, I am trying to find a formula which will allo
us to adjust our profit margin either up or down. Lets say I want t
increase our margin by 3%.
Please see the worksheet on my website. It's so much better than tryin
to explain it.

Thank you, Paul


Cell B4 is calculated based on the % value entered into cell C2. I a
looking for a formula to enter into Cell C1 which will return th
percentage value that I would need to enter into cell C2 in order t
achieve an increase or decrease of cell B4 by the amount shown in cel
A1

=+C2/((1+A1)