Results 1 to 5 of 5

Thread: Need help to calculate Square Footage in Microsoft Excel

  1. #1
    Join Date
    Jun 2011
    Posts
    21

    Need help to calculate Square Footage in Microsoft Excel

    I want to create a spreadsheet so that I can enter measurements for a house & have the total square footage displayed. I am having issues with the calculations due to feet & inches. Any suggestions or tips.

  2. #2
    Join Date
    Feb 2009
    Posts
    107

    Re: Need help to calculate Square Footage in Microsoft Excel

    You must use the format "number" to calculate how many hours you need to know the unit. Basically there is no exact formula to do this. But you can make the same if you know the entire calculation how square feet works. You cannot directly find a reference in Excel. There are other ready to use calculator for this which you can download for free and use.

  3. #3
    Join Date
    Nov 2009
    Posts
    61

    Re: Need help to calculate Square Footage in Microsoft Excel

    I have a very short example that might help you. In cell A2 put the square meters. Then in cell B2 put the hour. Then the formula in cell B3 will be = B2/A2. The cells are formatted as numbers, entered as decimal hours (5 hours and 15 minutes to write 5.25). Length times width gives the area, whether in mm ², cm ² or m². Also you can specify the inches to meters.

  4. #4
    Join Date
    Apr 2014
    Posts
    1

    Re: Need help to calculate Square Footage in Microsoft Excel

    I need help creating a formula in excel to Calculate square footage this is what I have.
    lot width (front) 18.41
    lot width (back) 15.00
    lot Lenght (right) 25.00
    Lot Lenght (back) 25.00

  5. #5
    Join Date
    Dec 2007
    Posts
    2,291

    Re: Need help to calculate Square Footage in Microsoft Excel

    Quote Originally Posted by eflores View Post
    I need help creating a formula in excel to Calculate square footage this is what I have.
    lot width (front) 18.41
    lot width (back) 15.00
    lot Lenght (right) 25.00
    Lot Lenght (back) 25.00
    You can go with the VBA answer so that the formula is atleast readable. Below is a new function called SQFT() which you can add to your workbook to make it easy:

    Code:
    Function SQFT(RNG As Range) As Single
    'Convert text strings like 12'5"x10'6" into square footage
    If RNG.Cells.Count > 1 Then
        SQFT = "1 cell only"
        Exit Function
    End If
    
    Dim MyArr, i As Long
    
    MyArr = Split(Replace(Replace(Replace(Replace(RNG, "'", "^"), " ", ""), """x", "^"), """", "^"), "^")
    
    SQFT = ((MyArr(0) * 12) + MyArr(1)) * ((MyArr(2) * 12) + MyArr(3)) / 144
    End Function

Similar Threads

  1. How to calculate ages in Microsoft Excel
    By vALaNCiA in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 06:17 PM
  2. How to calculate overtime in Microsoft Excel
    By Purujeet in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 08:11 PM
  3. Replies: 2
    Last Post: 07-02-2012, 05:56 PM
  4. How to calculate chronological age in Microsoft Excel
    By Mr.Pandhre in forum MS Office Support
    Replies: 4
    Last Post: 27-01-2012, 07:18 PM
  5. How to calculate Autocorrelation in Microsoft Excel
    By connoisseur in forum MS Office Support
    Replies: 4
    Last Post: 18-01-2012, 05:43 PM

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
  •  
Page generated in 1,708,637,210.50241 seconds with 17 queries