I had a formula ready to go and then noticed that you posted from excelbanter.com.
Does anybody there ever acknowledge a response to a question?
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Special Print XL add-in: rows to repeat a bottom)




"Abbeypost"
wrote in message
...

I run a copy shop and want to calculate the total price based on a scale
as follows:

1 - 100 20p
101 - 250 15p
251 - 500 10p
500+ 8p

If the total copies are 400, the total price should be:

100 @ 20p = £20
150 @ 15p = £22.50
150 @ 10p = £15.00

Total price = £57.50

If the total copies are entered in H5 and the total to be paid is shown
in H14, please give the formula and the cell into which it must go.

I have tried to follow other peoples explanations without success,
that's why I have included the information above.

Thanks in anticipation of saving my sanity
--
Abbeypost

I know it sound pathetic, but I forgot where I had asked the question, hence the lack of a reply. The point of this is to maintain the margin and smooth out the price. We don't want to say X are at one price or Y are at another, rather the price for X is ***. This is driving me nuts.