View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
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