Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Square Feet to Gallons | Excel Worksheet Functions | |||
how do I enter a square feet symbol in excel? | New Users to Excel | |||
how many square feet to an acre | Excel Worksheet Functions | |||
Can I use excell to draw a rectangle and come up with square feet | Excel Worksheet Functions | |||
Calculate formulas with feet & inches | Excel Worksheet Functions |