+ Reply to Thread
Results 1 to 7 of 7

formula to convert inches to square foot

  1. #1
    Registered User
    Join Date
    12-15-2008
    Location
    USA
    Posts
    9

    formula to convert inches to square foot

    I need a formula to automatically convert inches to square feet.
    I have =IF(G5>12,G5/144)
    and G5 is the cell used to enter your inch value. The formula wrks great, but only if you enter over 12 inches. I'm pretty sure Im on the right track, just need to know how to add in the part about if its less than 12 inches it should be multiplied by 12.
    Last edited by romettekitty; 12-30-2008 at 06:08 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,672
    If G5 is in square inches, square feet is G5/144. There's no need to test the value first.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    12-15-2008
    Location
    USA
    Posts
    9
    I know.
    I use the formula: =IF(G5>12,G5/144)
    If i put the number 14 into the cell G5 it works great. But enter 8.5 and it gives me FALSE.
    So.....
    I change the overal formula to: =IF(G5<12,G5/12)
    Then I can enter a number under 12 and it will calculate it correctly.
    My question again is-How do I combine the two formulas so that I can enter either number and have it calculate the result in square feet.

  4. #4
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,672
    Just =G5/144

  5. #5
    Registered User
    Join Date
    12-15-2008
    Location
    USA
    Posts
    9
    hmmmm....nutin' like feeling stupid.
    I guess maybe I was thinking it should be harder than that?

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,672
    We all get blind spots.

    If that sorts it, would you please mark the thread as solved?

    Click the Edit button on your first post in the thread

    Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

    If more than two days have elapsed since your first post, ask a moderator to mark it.

  7. #7
    Registered User
    Join Date
    08-23-2014
    Location
    Toronto, CAN
    MS-Off Ver
    2007
    Posts
    1

    Re: formula to convert inches to square foot

    I am an excel newbee 100% when it comes to creating formulas. And when i found this thread i delighted.
    However it is not working for me at all. Please help!

    In col A cell 1 i want to convert my measurements 17 inches widith multiplied 53 inches length and would like to say equals 20 sq ft.(not the correct answer just an example) in col B cell 1.

    Can anyone help me out?

    Cheers!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1