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

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

i mean the cost will be start fromfirst 1
take 1 or 10 the price will be same
it mean the charge will be per 10 units

"Shane Devenshire" wrote:

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

in B1 put
=10*(INT((A1-1)/10)+1)

FROM SA wrote:

i mean the cost will be start fromfirst 1
take 1 or 10 the price will be same
it mean the charge will be per 10 units

"Shane Devenshire" wrote:


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

=CEILING(A1,10)
or
=ROUNDUP(A1,-1)


"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

Let A1 represents the cost you have mentioned
Select cell B1 and enter following formula
=IF(AND(A1=1,A1<=10,10,IF(AND(A1=20,A1<=30,20))


Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com