Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
<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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
goal seek | Excel Discussion (Misc queries) | |||
Goal seek gone | Excel Worksheet Functions | |||
Goal Seek | Excel Worksheet Functions | |||
Goal Seek | Excel Discussion (Misc queries) | |||
Goal Seek | Excel Worksheet Functions |