View Single Post
  #3   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?

Thanks Lee! I must have entered it wrong the first time!

"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:

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