I need to solve this equation. The end goal is to be able to create a worksheet where I can set a goal profitability for a project and have the spreadsheet kick out the suggested price. Here is the equation:
(Price - Labor - Database - Commission)/Price = % profitability
Labor is assumed to be a constant.
Commission has the following equation: Commission = (Price - Labor - Database)*.14
So basically I need to solve for Price and I can't remember for the life of me how to get rid of the parentheses.
Simple Version: (P - L - D - ((P - L - D)*.14))/P = X (Solve for P)
Any help would be incredibly appreciated.