davecoppins
New Member
- Joined
- Nov 13, 2018
- Messages
- 11
Hope someone can help
I have a progressive pricing calculation which works as the purchase price increases, the profit margin decreases.
I would like to add an "IF" function to this (unless there is something better) which looks at sales volume and adds an additional % off the selling price or reduces the margin depending on volume.
So: cost price is £10.00 so add a mark on of 150% but if sales volume is 50 this year add a mark on of 140% / 100 this year add 130% / 150 this year add 120% etc.
The markon calculation is currently =(LOOKUP(AH2,'Markon Value'!M$3:N$68)+1)*AH2
Thanks in advance
I have a progressive pricing calculation which works as the purchase price increases, the profit margin decreases.
I would like to add an "IF" function to this (unless there is something better) which looks at sales volume and adds an additional % off the selling price or reduces the margin depending on volume.
So: cost price is £10.00 so add a mark on of 150% but if sales volume is 50 this year add a mark on of 140% / 100 this year add 130% / 150 this year add 120% etc.
The markon calculation is currently =(LOOKUP(AH2,'Markon Value'!M$3:N$68)+1)*AH2
Thanks in advance