Topcat2311
New Member
- Joined
- Feb 18, 2016
- Messages
- 3
Hi
This has annoying me for days hence the post - i'm almost certain the calculation can be done, but it's eluding me...
Basically I have a price list which gives me the % mark up/discount from trade on a range of products (so no fixed cost "price"). I need to create a formula in the "required discount" column that reacts to a value being placed in the "GP" column (in other words if I want to make 20% on an item it would calculate the discount from trade)
Example -
Range A has a discount from trade of 35%
Item 1 is trade £250
Cost £162.50
Item 2 is trade £350
Cost £227.50
Now if you wanted to sell both of these items and make 20% margin, you’d divide cost by 0.80
Item 1 - £203.12
Item 2 - £284.38
This makes the percentage discount from trade 18.75% to = 20% margin - but try as I might I can't figure out the formula to calculate this (and thus apply to other "ranges".
Can anyone out there put me out of my misery?
TC
This has annoying me for days hence the post - i'm almost certain the calculation can be done, but it's eluding me...
Basically I have a price list which gives me the % mark up/discount from trade on a range of products (so no fixed cost "price"). I need to create a formula in the "required discount" column that reacts to a value being placed in the "GP" column (in other words if I want to make 20% on an item it would calculate the discount from trade)
Example -
Range A has a discount from trade of 35%
Item 1 is trade £250
Cost £162.50
Item 2 is trade £350
Cost £227.50
Now if you wanted to sell both of these items and make 20% margin, you’d divide cost by 0.80
Item 1 - £203.12
Item 2 - £284.38
This makes the percentage discount from trade 18.75% to = 20% margin - but try as I might I can't figure out the formula to calculate this (and thus apply to other "ranges".
Can anyone out there put me out of my misery?
TC