Bassplaya7
New Member
- Joined
- Jul 2, 2010
- Messages
- 14
I am using this current formula to calculate my profit margin on product I sell.
=(A8-B8)/A8
<table width="195" border="0" cellpadding="0" cellspacing="0"><col style="width: 45pt;" width="60" span="2"> <col style="width: 56pt;" width="75"> <tbody><tr style="height: 18pt;" height="24"> <td class="xl26" style="height: 18pt; width: 45pt;" width="60" height="24">Price</td> <td class="xl27" style="width: 45pt;" width="60">Cost</td> <td class="xl27" style="width: 56pt;" width="75">Percentage</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" align="right" height="17">$3.79</td> <td class="xl25" align="right">$2.00</td> <td class="xl24" align="right">47.23%</td> </tr> </tbody></table>
I would like to be able to put in the Cost of the Product and desired profit margin to get the retail price. Can anyone help Please?
<table width="195" border="0" cellpadding="0" cellspacing="0"><tbody><table width="195" border="0" cellpadding="0" cellspacing="0"> <col style="width: 45pt;" width="60" span="2"> <col style="width: 56pt;" width="75"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; width: 45pt;" width="60" height="17">Cost</td> <td class="xl27" style="width: 45pt;" width="60">Margin</td> <td class="xl27" style="width: 56pt;" width="75">Price</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" align="right" height="17">$2.00</td> <td class="xl28" align="right">45%</td> <td class="xl24"></td> </tr> </tbody></table></tbody></table>
=(A8-B8)/A8
<table width="195" border="0" cellpadding="0" cellspacing="0"><col style="width: 45pt;" width="60" span="2"> <col style="width: 56pt;" width="75"> <tbody><tr style="height: 18pt;" height="24"> <td class="xl26" style="height: 18pt; width: 45pt;" width="60" height="24">Price</td> <td class="xl27" style="width: 45pt;" width="60">Cost</td> <td class="xl27" style="width: 56pt;" width="75">Percentage</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" align="right" height="17">$3.79</td> <td class="xl25" align="right">$2.00</td> <td class="xl24" align="right">47.23%</td> </tr> </tbody></table>
I would like to be able to put in the Cost of the Product and desired profit margin to get the retail price. Can anyone help Please?
<table width="195" border="0" cellpadding="0" cellspacing="0"><tbody><table width="195" border="0" cellpadding="0" cellspacing="0"> <col style="width: 45pt;" width="60" span="2"> <col style="width: 56pt;" width="75"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt; width: 45pt;" width="60" height="17">Cost</td> <td class="xl27" style="width: 45pt;" width="60">Margin</td> <td class="xl27" style="width: 56pt;" width="75">Price</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt;" align="right" height="17">$2.00</td> <td class="xl28" align="right">45%</td> <td class="xl24"></td> </tr> </tbody></table></tbody></table>