Is this possible

[God33]

I want to make a price list for all the glass we supply. In column A I would list all our products. As we sell glass on a square metre rate is there a way I can select a product from say A5 and the input the height of the glass in b5 and the width in d5 and in that row set a sq metre rate and the the final price is given in say f5?

Example- size x size = price

im probably really over complicating this

 

[God33]

All figured. I was putting it all in one column....Div

 

[God33]

Last question honest.
Can I add a quantity row so next to size x size/qty/net/vat/total
everything else works fine at the moment

 

[Fluff]

Something like this

Excel 2013 32 bit
	A	B	C	D	E	F	G
1	Product	Height	Width	Qty	Net	Vat	Total
2	Prod1	0.5	0.25	10	31.25	6.25	37.5
3	Prod2	1	0.5	20	250	50	300
4	Prod3	1.5	0.75	30	843.75	168.75	1012.5
5	Prod4	2	1	10	500	100	600
6	Prod5	2.5	1.25	20	1562.5	312.5	1875
7	Prod6	3	1.5	30	3375	675	4050
8	Prod7	3.5	1.75	10	1531.25	306.25	1837.5
SBD

Cell Formulas
Range	Formula
E2	=B2*C2*D2*25
F2	=(E2*0.2)
G2	=E2+F2

 

[God33]

Exactly like that. you didn't just do that did ya

 

[Fluff]

you didn't just do that did ya

Yup