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.
Printable View
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.
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.
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.
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:Quote:
Originally Posted by eflores
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