how i dow the following formal in excel

[FROM SA]

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

 

[Shane Devenshire]

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?

 

[Teethless mama]

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

 

[Chris Bode]

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

 

[FROM SA]

thank you for reply

your formula dont work with excel

the formula which i mean it is if i tak obe product or 10 will be same afte
the 10 will be callect for each 10 products again

so if i take

1 = $10
2= $10 UP PRODUCT NO. 10

THAN AT PRODUCT NO ELVEN THE PRICE WILL BE $20 DOLLER
11 UP 20 THE PRICE WILL BE 20 SO FOR EACH 10 PRODUCTS THE COST WILL BE CHANGE

IF THE FORMUL IN b1 AND I WRITE A1 THE NO. OF PRODUCT EH PRICE WILL APEAR IN
B1

 

[FROM SA]

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

 

[Bob I]

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

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

: