Hi David

you could use equal to or less than 10 and greater than 10. you could also
assume parts equal to or greater than 1000 would be @25%

Thanks

Andy

"David Biddulph" wrote:

What about between 10.00 and 11.00 or between 50.00 and 51.00 or ... or
greater than 10000?
Or are the inputs contrained to being integers and to being no greater than
10k?
--
David Biddulph


"Andy K" wrote in message
...
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