Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula using cost and margin % to get retail price?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula using cost and margin % to get retail price?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to determine selling price with cost known @ X margin? | Excel Worksheet Functions | |||
rounding a number created by a formula to a retail price | Excel Worksheet Functions | |||
Cost to Retail Price Formula - some help pse | Excel Worksheet Functions | |||
Converting cost price to retail in vast array | Excel Worksheet Functions | |||
Cost vs retail | Excel Discussion (Misc queries) |