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

 

[David Biddulph]

1. You haven't quoted the relevant parts of the message to which you are
trying to reply
2. Your formula has invalid syntax and won't be accepted by Excel
3. There are ranges of input which you haven't covered

 

[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

: