I would like to increase the mark up on spares based on the cost price of the
part.
Example
£0.00 - 10.00 = 200%
£11.00-£50.00 = 100%
£51.00-£100.00 = 85%
£101.00-£200.00 = 60%
£201.00-£300.00 - 45%
£301.00-£500.00 = 30%
£501.00-£1000.00 = 35%
£1001.00-£10000.00 = 25%

therefore if the cost of a spare part in cell A1 =£400.00 cell A2 should
read £520.00

Thanks in anticipation Andy