Results 1 to 5 of 5
Thread: Feet and Inches (XP)

20030724, 18:33 #1
 Join Date
 Jan 2001
 Location
 Fontana, California, USA
 Posts
 625
 Thanks
 0
 Thanked 0 Times in 0 Posts
Feet and Inches (XP)
It's me  again! I have a multitude of sheets of paper with measurements of rooms. The measurements are, for example, 30'4" x 24' 3"  I need a formula that will look at these numbers and calculate the square feet of this space.
Can someone help me?
Thanks in advance
Aunt Linda

20030724, 19:12 #2
 Join Date
 Jun 2001
 Location
 New York, New York, Lebanon
 Posts
 1,449
 Thanks
 1
 Thanked 1 Time in 1 Post
Re: Feet and Inches (XP)
<img src=/S/hello.gif border=0 alt=hello width=25 height=29> Aunt Linda
When will you be visiting us this summer, with the fruit cake in hand... Oh <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15> different Aunt Linda.
OK you say that you have these cells with these measurements, are they entered as text, or complex numbers?
To get the square footage, well you multiply the length by the width, its as simple as that, but then if 30'4 is entered as text, then you need to convert it to numbers, and then do the multiplication. Maybe you can also look at the <font color=red> CONVERT </font color=red> function maybe you want to see it all in feet or inches.
Hope this helps...
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

20030724, 19:27 #3
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Feet and Inches (XP)
Here is a formula that will work if you always use that form.
=(VALUE(MID(A1,1,FIND("'",A1)1))+VALUE(MID(A1,FIND("'",A1)+1,FIND(CHAR(34),A1)FIND("'",A1)1))/12)*(VALUE((MID(A1,FIND("x",A1)+1,FIND("'",A1,FIND ("x",A1))FIND("x",A1)1)))+VALUE((MID(A1,FIND("'",A1,FIND("x",A1))+1,FIN D(CHAR(34),A1,FIND("x",A1))FIND("'",A1,FIND("x",A1))1)))/12)
You might have to create a custom function if you have different forms (the formula I propose does REQUIRE both FEET and INCHES for measurements. You can not have 12' x 6" you must have 12'0" x 0'6".
A custom function could get around that. The biggest problem is deciding on all the different variants to check for.
Steve

20030724, 21:26 #4
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Feet and Inches (XP)
I thought about your request again. You mention "sheets of paper" with the implication that they are NOT yet in a spreadsheet?
If not enter them in separate columns:
Col A: Length Ft portion
Col B: Length inch portion
Col C: Width Ft portion
Col D: Width inch portion
Then the formula:
<pre>=(A1+B1/12)*(C1+D1/12)</pre>
will give you square feet directly.
If you want this "separated form" into the form you list:
Something like this will work:
=IF(A1=0,"",A1&"' ")&IF(B1=0,"",B1&CHAR(34))&" "&CHAR(215)&" "&IF(C1=0,"",C1&"' ")&IF(D1=0,"",D1&CHAR(34))
This equation will eliminate the 0" or 0' from the display.
Steve

20030725, 14:08 #5
 Join Date
 Jan 2001
 Location
 Fontana, California, USA
 Posts
 625
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Feet and Inches (XP)
I was referring to actual PAPER. And  I'm sorry I didn't post this yesterday  I did have the "duh" moment when I said to myself, "Self, you knothead, just put the feet and inches into separate columns and then write this really simple formula." So I did  and it's all good now.
Thanks for thinking about me  the fruit cake is in the mail.
Aunt Linda