Excel formula

[ahamed85]

HELLO,

Promotion	Promo.price	Regular Price	sold qty	sold price	Promo price sold qty	Regular price Qty
1+1	5	4	11	29	?	?

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Please share formula..

 

[stoure]

Hi!
what do you mean by 1+1 ?
Can you give us more details about the input values and computation needed ?

 

[ahamed85]

Hi
if buy 2 qty. price is $5.
if buy 3 qty. promo price is $5 for 2 qty, remaining 1 qty is $4, total amount $9.

Please do the needful

 

[Dave Patton]

Excel 2010
	A	B	C	D	E	F	G
1	Promotion	Promo.price	Regular Price	sold qty	Sale	Promo price sold qty	Regular price Qty
2	1+1	5	4	11	29	10	1
3		5	4	3	9	2	1
1d

Cell Formulas
Range	Formula
E2	=INT(D2/2)*B2+MOD(D2,2)*C2
E3	=INT(D3/2)*B3+MOD(D3,2)*C3
F2	=INT(D2/2)*2
F3	=INT(D3/2)*2
G2	=D2-F2
G3	=D3-F3