Trying to convert 2 cells from inches to inches and feet. Then need to multiply them together to get a square footage. All in one cell

[TylerGraham]

Hello All,

Here's the issue i'm having.

In cell A3 i have 66". I take the formula =INT(A3/12) & " ft. " & MOD(A3,12) & " in." which gives me 5ft. 6in. - PERFECT

Now I get lost. Lets say C3 is 66" as well. i need that to convert to (5ft. 6in.), then I need to multiply A3 and C3 together to get my square.

Here is what i tried =(INT(A3/12) & " ft. " & MOD(A3,12) & " in.")*(INT(C3/12) & " ft. " & MOD(C3,12) & " in.") but this kicks out a value error.

I also tried =SUMPRODUCT(INT(A3/12) & " ft. " & MOD(A3,12) & " in.")*(INT(C3/12) & " ft. " & MOD(C3,12) & " in.") still a value error.

So i basically need to convert A3 to Feet and Inches. C3 to feet and inches and multiply them together in one cell.

Looking for some help on how to correct that formula or alternative ways to do this.

 

[MARK858]

So i basically need to convert A3 to Feet and Inches. C3 to feet and inches and multiply them together in one cell.

Going by your quote won't the formula below work i.e multiplying the 2 cells containing 66 together then converting to feet and inches?

=INT(A3*C3/12) & " ft. " & MOD(A3*C3,12) & " in."

or do you actually need to multiply the feet and inches separately (if this is the case can you manually work out and post the result you are expecting)

 

[Snakehips]

TylerGraham,

Welcome to MrExcel.

I take the formula =INT(A3/12) & " ft. " & MOD(A3,12) & " in." which gives me 5ft. 6in. - PERFECT

Suggests that A3 and C3 contain number values e.g. 66 not text 66" ????

If so then for text square footage answer maybe...

Excel 2007
	A	B	C	D
3	66		66	30.25 Sq Ft
Sheet13

Cell Formulas
Range	Formula
D3	=A3*A3/144&" Sq Ft"

Hope that helps.

 

[TylerGraham]

That is perfect. I feel like an idiot. Pulling my hair out trying to figure this out and when i see it. (DUH)

Thanks