ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   complicated excel formula may need an algebra wiz (https://www.excelbanter.com/excel-discussion-misc-queries/448608-complicated-excel-formula-may-need-algebra-wiz.html)

[email protected]

complicated excel formula may need an algebra wiz
 

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 us to adjust our profit margin either up or down. Lets say I want to increase our 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

Quote:

Originally Posted by (Post 1611263)
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 us to adjust our profit margin either up or down. Lets say I want to increase our 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.

=+C2/((1+A1))


All times are GMT +1. The time now is 10:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com