Multiply Measurement X # rooms

[steveps1234]

I'm trying to create a formula that multiplies various room measurements times the number of rooms needed for an employee floor plan. For example, I have 3 rooms measuring 9'-10" (I'm using that format for the room measurement). I want to multiply 3 X 9'-10" and get a total for square feet needed. Thanks!

Steve C

 

[immyjimmy]

Steve,

Here's something that might work - if all rooms are the same size. You should be able to customize it as needed though.

Book1
	A	B	C	D	E
1	X	118	inches
2			equals
3		9	feet	10	inches
4	Y	124	inches
5			equals
6		10	feet	4	inches
7	SqIn	14632
8	SqFt	101.61
9
10	Noofrooms	3
11	TotalSqFt	304.83
Sheet1

HTH,
Jim

PS. Not sure where the "" text is coming from. It seems to be either blank cells or spaces between words...

 

[halleyf]

if you keep the feet and inch data in seperate cells it can be quite simple.
i.e. 10'-6" would be
A1 = 10
A2 = 6

A1 + A2/12 = 10.5 (decimal feet)

multiply two decimal feet values together and you have square ft.

 

[steveps1234]

Thank you both for your responses. I'll give them a try!