Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    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

  2. #2
    Bronze Lounger
    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>

  3. #3
    WS Lounge VIP sdckapr's Avatar
    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

  4. #4
    WS Lounge VIP sdckapr's Avatar
    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

  5. #5
    5 Star Lounger
    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 knot-head, 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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •