View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Renae Renae is offline
external usenet poster
 
Posts: 9
Default Formula using cost and margin % to get retail price?



"lee" wrote:

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

"Renae" wrote: 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.

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