How do I calculate square footage in excel ?

**dukemom** · January 16th 07, 10:16 PM posted to microsoft.public.excel.misc

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???

**Chip Pearson** · January 16th 07, 10:39 PM posted to microsoft.public.excel.misc

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???

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I calculate the root of a number using Excel?	Arthur Yeager	Excel Worksheet Functions	4	May 10th 07 08:35 AM
how to calculate surface area in excel chart	k	Charts and Charting in Excel	1	January 18th 06 03:07 PM
unhide menu bar in excel - just disappeared	Sean	Setting up and Configuration of Excel	11	December 4th 05 08:01 PM
how to calculate overtime automatically on Excel timesheets	Jeanine	Excel Worksheet Functions	1	November 11th 05 06:25 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	1	January 5th 05 08:36 AM