Formula needed please

[carla7216]

Item to Order	Quantity	Unit of Measure	Retail Price	Tax 6.35%	15% Discount	Total Cost Paid
Shampoo	3​		$ 7.99	$ 8.50	$ 1.27	$ 7.22

Hello, my question is: How do I create a formula for the "Total Cost Paid" to increase with the "Quantity" needed?

 

[alansidman]

Is the Retail Price for one unit or three in your example?

 

[carla7216]

Is the Retail Price for one unit or three in your example?

Good Evening,

The "Retail Price" is for one unit, but I need for the formula to change if the quantity needed, changes.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	Item to Order	Quantity	Unit of Measure	Retail Price	Tax 6.35%	15% Discount	Total Cost Paid
2	Shampoo	3		7.99	25.49	3.82	21.67
Lists

Cell Formulas
Range	Formula
E2	E2	=D2*B2*1.0635
F2	F2	=E2*0.15
G2	G2	=E2-F2

 

[carla7216]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	Item to Order	Quantity	Unit of Measure	Retail Price	Tax 6.35%	15% Discount	Total Cost Paid
2	Shampoo	3		7.99	25.49	3.82	21.67
Lists

Cell Formulas
Range	Formula
E2	E2	=D2*B2*1.0635
F2	F2	=E2*0.15
G2	G2	=E2-F2

Good Morning, thank you so much. That worked! I appreciate your time and expertise. Have a blessed day.

 

[Fluff]

Glad we could help & thanks for the feedback.