Hi,

Are you really saying that the price is $10 for 1 to 10 items and $20 for 11
to 20 itmes? In other words are the 2-10 items free? Or are you trying to
do a cost per item? In which case are you really charging more per items if
they buy more? 1 egg is $1 but 2 egges is $30?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"FROM SA" wrote:

hi all

how i can dow the following formail in excel

if i hvae products cost as following

the cost of part $10 but if customer take one the coste will be $10
if take 2 the cost will be same $10
so from 1 to 10 cost will not change and if take 11 part the cost wil be 20 $
12 parts = $20
20 parts = $ 20