I have made a calculator to calculate selling price from cost but I need help to make it tiered so the things I buy for a smaller price arer calculated higher than the more expensive ones.
I am not a big wiz kid In excel but know some basic stuff this is what i have made so far....
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<colgroup><col style="width: 60px"><col width="133"><col width="24"><col width="72"><col width="15"><col width="83"></colgroup><tbody>
</tbody>
Cell E5 Has the formula =1-$D$5 but I need it to change depending on the cost like this.
I want to have this formula run if I put cost into the "blue" field E4.
Any help with this would be greatly appreciated
I am not a big wiz kid In excel but know some basic stuff this is what i have made so far....
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
Parts Gross Profit Margin Calculator | |||||
Only "Blue" cells can be modified. | |||||
Profit Margin | = | 0.25 | 75% | ||
Items | Description | Cost | Selling Price | ||
Item 1 | $100.00 | $ 133.33 | |||
Item 2 | $ - | ||||
Item 3 | $ - | ||||
Item 4 | $ - | ||||
Item 5 | $ - | ||||
Item 6 | $ - | ||||
Item 7 | $ - | ||||
Item 8 | $ - | ||||
Item 9 | $ - | ||||
Item 10 | $ - | ||||
Item 11 | $ - | ||||
Item 12 | $ - | ||||
Item 13 | $ - | ||||
Item 14 | $ - | ||||
Item 15 | $ - | ||||
Item 16 | $ - | ||||
Item 17 | $ - | ||||
Item 18 | $ - | ||||
Item 19 | $ - | ||||
Item 20 | $ - | ||||
<colgroup><col style="width: 60px"><col width="133"><col width="24"><col width="72"><col width="15"><col width="83"></colgroup><tbody>
</tbody>
Cell E5 Has the formula =1-$D$5 but I need it to change depending on the cost like this.
I want to have this formula run if I put cost into the "blue" field E4.
- $.01 to $1.00 75% GP and 300% markup
- $1.01 to $5.00 71% GP and 245% markup
- $5.01 to $12.00 65% GP and 185% markup
- $12.01 to $26.00 60% GP and 150% markup
- $26.01 to $38.00 55% GP and 124% markup
- $38.01 to $50.00 50% GP and 100% markup
- $50.01 to $62.00 45% GP and 82% markup
- $.6201 to $74.00 40% GP and 67% markup
- $74.01 to $86.00 35% GP and 55% markup
- $86.01 and up 30% GP and 43% markup
- $.01 to $1.00 75% GP and 300% markup
Any help with this would be greatly appreciated