multiplying 3 different rate for different nos of products

[harsharmani]

product a b c d e bioprine Rs 10 for 5 product <tbody> </tbody> rs 20 for 10 product <tbody> </tbody> rs 30 for 15 product <tbody> </tbody> no of product required <tbody> </tbody> rate <tbody> </tbody> customer will enter desired no of product in D column and rate shd reflect in E coloumn <tbody> </tbody> 10 20 30 if I type from 1 to 15 in D column automatically the rate shd come in E colum <tbody> </tbody> <tbody> </tbody>
please help me and do the need full

<tbody>
</tbody>

 

[BrianJN1]

Re: multiplying 3 diifrent rate for diffrent nos of products

I regret that this is not very helpful.
I think that you are discussing discounted pricing on volume of product.
Please explain exactly what you require rather have someone try to second guess your intention.

 

[harsharmani]

Re: multiplying 3 diifrent rate for diffrent nos of products

hi
you are correct it is discounted pricing on volume of product
when customer enter his desired quantity . pricing for the same should appear

 

[harsharmani]

Re: discounted pricing on volume of product

hi
table woud be

	minimum order qty 5	minimum order qty 10	minimum order qty 15	Quantity required	price
apple	14	12	10

<tbody>
</tbody>

the above table for reference which tell discounted pricing on volume of product
i want formula for this. when customer enter desired quantity automatically in price column rate should appear.

Please help

harish

 

[BrianJN1]

Re: discounted pricing on volume of product

This small table does what your table requires:

Prod	Rate 5	Rate 10	Rate 15	Qty	Price
Apple	14	12	10	20	200

<colgroup><col style="width:48pt" width="64" span="6"> </colgroup><tbody>
</tbody>

This goes from Col A to Col F.
The formula in F2 is:
=IF(E2<5,"N/A",IF(AND(E2>4,E2<10),E2*B2,IF(AND(E2>9,E2<15),E2*C2,E2*10)))

Not: I have included the situation where a value below your lowest value is reported as Not Available, it is not a computer error.

 

[harsharmani]

Re: discounted pricing on volume of product

This small table does what your table requires:

Prod	Rate 5	Rate 10	Rate 15	Qty	Price
Apple	14	12	10	20	200

<tbody>
</tbody>

This goes from Col A to Col F.
The formula in F2 is:
=IF(E2<5,"N/A",IF(AND(E2>4,E2<10),E2*B2,IF(AND(E2>9,E2<15),E2*C2,E2*10)))

Not: I have included the situation where a value below your lowest value is reported as Not Available, it is not a computer error.

dear sir,

in this formula b clooumn and c coloumn is not reading if i type 4 it shd mulitiply with 14 and if type 7 it shd multiply with 12... hope uu understood my query
please help

 

[BrianJN1]

Re: discounted pricing on volume of product

Apologies, I know that in your first comment you were mentioning "typing 1 to 15" but after this table of yours

table woud be

	minimum order qty 5	minimum order qty 10	minimum order qty 15	Quantity required	price
apple	14	12	10

<tbody>
</tbody>

I was thinking that the customer's minimum order was 5 and so I structured the formula around that value.
Ok then, going back to allowing a minimum order of 1 then enter the formula:

=IF(E2<6,E2*B2,IF(AND(E2>4,E2<11),E2*C2,E2*D2))

into F2.

 

[harsharmani]

Re: discounted pricing on volume of product

dear sir,

thank you very much

 

[BrianJN1]

Re: discounted pricing on volume of product

You're welcome.