how i dow the following formal in excel
 

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

how i dow the following formal in excel
 

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

how i dow the following formal in excel
 

=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

how i dow the following formal in excel
 

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
--
David Biddulph

Chris Bode wrote:
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

how i dow the following formal in excel
 

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


"Chris Bode" wrote:


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




--
Chris Bode

how i dow the following formal in excel
 

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

how i dow the following formal in excel
 

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