How do I calculate square footage in excel ?
I want to crate 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??? |
Answer: How do I calculate square footage in excel ?
Calculating Square Footage in Excel
1. Create a new spreadsheet in Excel and label the columns as "Length", "Width", and "Area". 2. In the "Length" and "Width" columns, enter the measurements for each room in feet and inches. For example, if a room is 12 feet and 6 inches long, enter "12'6" in the cell. 3. To convert the feet and inches to decimal format, use the following formula: Formula:
5. To calculate the area, multiply the "Length" and "Width" columns. To do this, enter the following formula in the "Area" column: Formula:
Formula:
|
How do I calculate square footage in excel ?
You need to convert your feet and inches values to numeric values. See
http://www.cpearson.com/excel/feetinches.htm and http://www.cpearson.com/excel/fractional.htm -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "dukemom" wrote in message ... I want to crate 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??? |
All times are GMT +1. The time now is 10:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com