How to Calculate discount for multiple items

[amkumar]

[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]Items[/TD]
[TD]Per Piece[/TD]
[TD]Qty[/TD]
[TD]Disc %[/TD]
[/TR]
[TR]
[TD="align: center"]Apple[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]Mango[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]Banana[/TD]
[TD="align: center"]12[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]Orange[/TD]
[TD="align: center"]18[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]6[/TD]
[/TR]
[TR]
[TD="align: center"]Grapes[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]Pineapple[/TD]
[TD="align: center"]26[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]2[/TD]
[/TR]
</tbody>[/TABLE]

Total Amt without Disc =
Total Amt with Disc =


how can i get both amounts in 2 different cells.


Thanks
Amit

 

[AlanY]

try

Book1
	A	B	C	D
1	Items	Per Piece	Qty	Disc %
2	Apple	10	2	4
3	Mango	15	3	5
4	Banana	12	5	2
5	Orange	18	4	6
6	Grapes	20	5	4
7	Pineapple	26	7	2
8
9	Total Amt without Disc =	479.00
10	Total Amt with Disc =	462.79
Sheet1

Cell Formulas
Range	Formula
B9	=SUMPRODUCT(B2:B7,C2:C7)
B10	=SUMPRODUCT(B2:B7,C2:C7,1-(D2:D7/100))