<I hope this is enough information.>
Not really
So I repeat my question:
<What data is in which cells?>
And I add:
what formulas are in which cells?
And can you explain what you are trying to achieve?
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
|I want to determine the profit margin between 20% and 30% from the Price to
| Customer and Total Cost.
|
| Set Cell: $D$18
| To value: 20%
| By Changing Cell $D$7
| I just don't know the formula for the Margin Cell which is D18.
|
| I hope this is enough information.
| ThankYou, Laura
|
|
| "Niek Otten" wrote:
|
| > Hi Laura,
| >
| > What data is in which cells?
| > And what do you fill in in the GoalSeek dialog?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| >
| > | How do I get -25% in the margin cell??? The formula I use, =D7*D9 gives me
| > | 0.25 insted of - 25%.
| > |
| > | Hourly Cost Direct Cost
| > | $30.00 $750.00
| > | $25.00 $1,000.00
| > | $25.00 $2,250.00
| > | $4,000.00
| > |
| > | Price to customer $4,000.00
| > |
| > | Tax Rate 25%
| > | Tax Costs $1,000.00
| > |
| > |
| > | Total Costs
| > | Staff $4,000.00
| > | Taxes $1,000.00
| > |
| > |
| > | Margin ??
| > |
| > |
| > |
| > |
| > |
| > |
| > |
| > | Thank you,
| > | Laura
| >
| >
| >