Hi,
I assume your list is in column A and cost in column B starting in row 2,
Quantities to be calculated in E2

=+IF(E2<=10,E2*B2,IF(AND(E210,E2<=20),((10*B2)+(E 2-10)*B3),IF(AND(E220,E2<=30),((10*B2)+(10*B3)+(E2-20)*B4),IF(E230,(10*B2)+(10*B3)+(10*B4)+(E2-30)*B5))))



"FROM SA" wrote:

Is it possible to do the following formal by Microsoft Office Excel 2003:
Products as following
If customer buy 10 parts the cost will be 5$ by parts
If take any number over 10 parts will be 5$ for first 10 and more will $4

Example if take 12 parts will be the price as following:
(10*5)+(2*4)=58
And this products price as following
0 part to 10 the price 5$
11 to 20 the price 4$
21 to 30 the price 3$
More than 30 the price will be 2$

Example

Customer buys 33 parts so we charge him as following

0 -10 we charge him 10 * 5 $= 50 $
11 €“ 20 10 * 4 $= 40$
21 -30 10 * 3$ = 30$
31 to 33 3 * 2$ = 6

So the total charge will be 126


please contact me on email: