Item price based on LENGHT/WIDTH at X$ for fabric prices

[matecheck]

I would like to create an invoce sytem in where I can put the lenght/width of a curtain that goes for $X/per sqf

INVOICE #

QTY | DESCRIPTION | $/SQF | L" | W" | TOTAL ITEM SQF | TOTAL PRICE
1 Curtains $2.25 38" 66" 17.42 $39.20
5 Curtains $2.25 38" 80" 105.55 $237.49

 

[AhoyNC]

Maybe something like this:

Book1
	A	B	C	D	E	F	G
1	QTY	DESCRIPTION	$/SQF	L"	W"	TOTAL ITEM SQF	TOTAL PRICE
2	1	Curtain	$ 2.25	38	66	17.42	$ 39.20
3	5	Curtain	$ 2.25	38	80	105.55	$ 237.49
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=ROUND((D2*E2)/144,2)*A2
G2:G3	G2	=F2*C2

 

[matecheck]

Maybe something like this:

Book1
	A	B	C	D	E	F	G
1	QTY	DESCRIPTION	$/SQF	L"	W"	TOTAL ITEM SQF	TOTAL PRICE
2	1	Curtain	$ 2.25	38	66	17.42	$ 39.20
3	5	Curtain	$ 2.25	38	80	105.55	$ 237.49
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=ROUND((D2*E2)/144,2)*A2
G2:G3	G2	=F2*C2

Thank you for you response, I appreciate you.
I have tried it, but I'm unsure if it's what I'm looking for.
I want for the word Curtain to automatically be $2.75 in the $ by sq tf section after I type the word
Price must be somehow related to the QTY section, no? as it affcets it directly.
1 100x60 curtains is only 41.67 sq ft; the 5 combined will be the total of 208.33 sq ft.

Units	Description	$/per sq tf	Length Inch	Width Inch	Total sq tf of units	Price
1	Curtains	$2.75	80	80	44.44	$122.21
5	Curtains	$2.75	100	60	208.33	$572.91
8	Curtains	$2.75	42	70	163.33	$449.16
1	Curtains	$2.75	60	70	29.17	$80.22

I basically just want to type qty number description and the measurments.
Everything else I want it to be automatic.
Can that be done?

 

[AhoyNC]

This should do what you want, but what if description is not Curtains?

Book2
	A	B	C	D	E	F	G
1	Units	Description	$/per sq tf	Length Inch	Width Inch	Total sq tf of units	Price
2	1	Curtains	$2.75	80	80	44.44	$122.21
3	5	Curtains	$2.75	100	60	208.33	$572.91
4	8	Curtains	$2.75	42	70	163.33	$449.16
5	1	Curtains	$2.75	60	70	29.17	$80.22
Sheet1

Cell Formulas
Range	Formula
F2:F5	F2	=ROUND((D2*E2/144)*A2,2)
G2:G5	G2	=ROUND(F2*C2,2)
C2:C5	C2	=IF(B2="Curtains",2.75,"")