Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default calculate square feet

I need to know how to calculate volume in square feet. Example:
51/2"X2'X58" (five and one-half inched by two feet by 58 inches)=? sq. feet

Thanks

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default calculate square feet

5 and half inch * 2 feet * 58 inch

=5.5*(2*12)*58 square inches.

to square feet
=5.5*(2*12)*58/144

=53.1666 square ft


PS: if you mean 5 feet and .5 inches then the calculation would be
=((5*12)+0.5)*(2*12)*58/144

If this post helps click Yes
---------------
Jacob Skaria


"Walt" wrote:

I need to know how to calculate volume in square feet. Example:
51/2"X2'X58" (five and one-half inched by two feet by 58 inches)=? sq. feet

Thanks

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,104
Default calculate square feet

If you are finding a volume then the answer is in CUBIC feet not SQUARE feet
=5.5*(2*12)*58 =7676 cubic inches
or
=5.5*(2*12)*58 /(12*12*12) =4.43 ft³
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Walt" wrote in message
...
I need to know how to calculate volume in square feet. Example:
51/2"X2'X58" (five and one-half inched by two feet by 58 inches)=? sq.
feet

Thanks


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 690
Default calculate square feet

Hi. One other way...


=PRODUCT(5.5/12, 2, 58/12)

=4.43 Cubic Feet

= = = = =
Dana DeLouis



Walt wrote:
I need to know how to calculate volume in square feet. Example:
51/2"X2'X58" (five and one-half inched by two feet by 58 inches)=? sq. feet

Thanks

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default calculate square feet

Oops; it is cubic feet....(my mistake)

and should be divided by (12*12*12)..

"Jacob Skaria" wrote:

5 and half inch * 2 feet * 58 inch

=5.5*(2*12)*58 square inches.

to square feet
=5.5*(2*12)*58/144

=53.1666 square ft


PS: if you mean 5 feet and .5 inches then the calculation would be
=((5*12)+0.5)*(2*12)*58/144

If this post helps click Yes
---------------
Jacob Skaria


"Walt" wrote:

I need to know how to calculate volume in square feet. Example:
51/2"X2'X58" (five and one-half inched by two feet by 58 inches)=? sq. feet

Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert Square Feet to Gallons Texins Karate Excel Worksheet Functions 4 June 9th 09 02:49 AM
how do I enter a square feet symbol in excel? summerlane New Users to Excel 4 September 16th 05 01:56 PM
how many square feet to an acre jculjk Excel Worksheet Functions 6 July 4th 05 03:28 PM
Can I use excell to draw a rectangle and come up with square feet Paul Excel Worksheet Functions 6 May 13th 05 02:18 AM
Calculate formulas with feet & inches Wayne hof Excel Worksheet Functions 10 January 30th 05 09:58 PM


All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"