Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sdmccabe
 
Posts: n/a
Default Mark up and Margin

I need a formula to produce a selling price when cost is known and desired
gross margin (on sales) is an input variable.

For example, cost equal $60, desired gross margin (percent) equals 40; the
result would be $100

Can you help a rookie?
  #2   Report Post  
Bill Kuunders
 
Posts: n/a
Default


A1 is cost price
B1 is percentage markup entered as a % i.e. 40% or as a general number
0.4

enter in C1

=A1/(1-B1)

--
Greetings from New Zealand
Bill K

"sdmccabe" wrote in message
...
I need a formula to produce a selling price when cost is known and desired
gross margin (on sales) is an input variable.

For example, cost equal $60, desired gross margin (percent) equals 40; the
result would be $100

Can you help a rookie?



  #3   Report Post  
sdmccabe
 
Posts: n/a
Default

Perfect Bill K - thanks!

"Bill Kuunders" wrote:


A1 is cost price
B1 is percentage markup entered as a % i.e. 40% or as a general number
0.4

enter in C1

=A1/(1-B1)

--
Greetings from New Zealand
Bill K

"sdmccabe" wrote in message
...
I need a formula to produce a selling price when cost is known and desired
gross margin (on sales) is an input variable.

For example, cost equal $60, desired gross margin (percent) equals 40; the
result would be $100

Can you help a rookie?




  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

Cost = $60

Margin is 40%

Result would be $84 in my estimation.


Gord Dibben Excel MVP

On Sat, 2 Jul 2005 16:14:01 -0700, "sdmccabe"
wrote:

I need a formula to produce a selling price when cost is known and desired
gross margin (on sales) is an input variable.

For example, cost equal $60, desired gross margin (percent) equals 40; the
result would be $100

Can you help a rookie?


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
To make a margin Michael Excel Discussion (Misc queries) 2 April 23rd 05 04:25 PM
print excel truncated on left margin Butterfly Excel Discussion (Misc queries) 1 April 15th 05 02:49 AM
gross profit margin formula julmcgrath Excel Discussion (Misc queries) 2 March 11th 05 04:01 PM
Can one have an extra margin gutter, for binding a document print. DaveT Excel Discussion (Misc queries) 1 February 14th 05 04:01 PM
how do I make the left margin of a header the same as the page ma. Dipper Excel Discussion (Misc queries) 1 January 12th 05 04:19 PM


All times are GMT +1. The time now is 11:36 AM.

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

About Us

"It's about Microsoft Excel"