Westy247365
New Member
- Joined
- Jul 1, 2022
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi, I would really appreciate a solution to the following issue. I currently have a profit calculator which enables me to enter a net cost of a product in E6 and then populate E10, E11, E12, E25, E27, E28, F25 & F26. Then when I enter my desired sale price in E15, it will show me the net profit in F23 and gross profit in F22 as a percentage.
What I would like it for this to be in reverse so that I just enter the net profit % I want in F23 and it to calculate a final selling price in E15.
I just can not figure out how to get it to do this becasue E18 & E19 are based on the final sale price and that is the figure I want it to calculate for me based on all the fees and net cost of the product.
I hope this makes sence. I would really appreciate if someone has a solution for this.
I am happy for the sheet to work with just the net profit being entered and remove the gross profit element if it is not possible to showe that on the sheet.
What I would like it for this to be in reverse so that I just enter the net profit % I want in F23 and it to calculate a final selling price in E15.
I just can not figure out how to get it to do this becasue E18 & E19 are based on the final sale price and that is the figure I want it to calculate for me based on all the fees and net cost of the product.
I hope this makes sence. I would really appreciate if someone has a solution for this.
I am happy for the sheet to work with just the net profit being entered and remove the gross profit element if it is not possible to showe that on the sheet.
