Invoicing and quotations

[mistersteve]

Hello, can anyone help please.
I require a formula to in the TOTAL column
,.

Quantity	Product Code	List Price	Per	Disc	Total
4	Item P	2.00	1	20.0%
2	Item T	3.50	100	15.0%

'
Thank you in advance

Steve Tooze

 

[Cubist]

Try:

Book1
	A	B	C	D	E	F
1	Quantity	Product Code	List Price	Per	Disc	Total
2	4	Item P	2	1	20.00%	6.40
3	2	Item T	3.5	100	15.00%	0.06
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=C2/D2*A2*(1-E2)

 

[mistersteve]

Cubist, thank-you for your answer
Kind regards