Formula using cost and margin % to get retail price?

R

Renae

I need a formula using product cost and margin % to get the retail price. So
far all I have tried are giving me the incorrect retail. I am using version
2003 if this is any help as to what I am doing wrong
 
L

lee

if your product cost is $100 and your retail is $133 your margin would be $33
Correct???

So the formular would be =100*1.33 to get a retail of $133
 
R

Renae

lee said:
if your product cost is $100 and your retail is $133 your margin would be $33
Correct???

So the formular would be =100*1.33 to get a retail of $133

: Would this be the same if I am using different margin percentages? I am assuming it will be but this sheet has got the best of me trying to get it fixed the correct way. Apparently he changes the margin % at times and it would be nice to have a formula instead of having to do it all by hand.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

margin formula 2
Margin Formula 2
Profit Margin 1
Calculate Margins 3
inventory Add, Cost, Sold, Sold price - formula 3
Formula for margin 1
gross margin 1
Using Margin to calculate Sell Price 3

Top