Thread: margin formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default margin formula

Well, margin is purely % difference from cost to price, so...

for price =cost*1+margin where margin is an actual % .2,.5, etc.

margin would be =(price-cost)*cost

So, if price is $1, cost is $.50, margin would be 100%

Make sense? Or are you going for somethign else?

"baseballguy" wrote:

I would like a formula that will solv for the missing variable when
calculating margin.

price cost and margin

I would like to calculate margin given price and cost, but I would also like
to come up with a price if I only hve cost and desired margin all with in the
same formula.

Can you help me.