Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default Please Help With Goal Seek

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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,440
Default Please Help With Goal Seek

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


"Laura" wrote in message ...
| 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


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default Please Help With Goal Seek

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 dont 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


"Laura" wrote in message ...
| 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



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,440
Default Please Help With Goal Seek

<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


"Laura" wrote in message ...
|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
|
|
| "Laura" wrote in message ...
| | 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
|
|
|


  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default Please Help With Goal Seek

that's okay...this is all so new to me. It's really hard for me to explain. I
just want to know the formula to get a -25% in the margin cell.... I'll keep
reserching for the answer

--
Thank you,
Laura


"Niek Otten" wrote:

<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


"Laura" wrote in message ...
|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
|
|
| "Laura" wrote in message ...
| | 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
|
|
|





  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default Please Help With Goal Seek

I went to Excel Custom Formats online and got my answer.
it is
=(D7-D16)/D7

Thank you for your time Niek. I appreciate you trying to help me considering
I could not explain myself.
Sincerely,
Laura


"Niek Otten" wrote:

<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


"Laura" wrote in message ...
|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
|
|
| "Laura" wrote in message ...
| | 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
|
|
|



  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 634
Default Please Help With Goal Seek

I do think you need a better business case than one that sees you with a
loss such as you describe though :-)

Either cut your costs or charge the customer more, because negative profits
such as yours won't keep the business alive.

Your answer is actually at odds with your request, where you had stated:-

<<....determine the profit margin between 20% and 30% from....

as -25% falls way outside those parameters. Are you sure you got all the
variables correct?

Regards
Ken..............


"Laura" wrote in message
...
I went to Excel Custom Formats online and got my answer.
it is
=(D7-D16)/D7

Thank you for your time Niek. I appreciate you trying to help me
considering
I could not explain myself.
Sincerely,
Laura


"Niek Otten" wrote:

<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


"Laura" wrote in message
...
|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
|
|
| "Laura" wrote in message
...
| | 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
|
|
|





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
goal seek tikchye_oldLearner57 Excel Discussion (Misc queries) 3 August 31st 06 02:52 PM
Goal seek gone [email protected] Excel Worksheet Functions 2 August 29th 06 04:57 PM
Goal Seek Mike Excel Worksheet Functions 3 January 23rd 06 04:39 AM
Goal Seek Jake Excel Discussion (Misc queries) 1 June 12th 05 05:55 AM
Goal Seek Tiya Excel Worksheet Functions 1 May 11th 05 12:38 PM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"