On 3/3/2010 2:16 AM, PlaceCarp wrote:
How do I calculate cubic feet in excel? I need to be able to do it two ways.
With all feet or with feet and inches. example... 2' x 4' x 3' or 2' x 4' x
1'-5" or 2' x 4' x 4". I have a construction master IV calculator that will
give me both answers in cubic feet. 2'x4'x3'= 24cubic feet or
2'x4'x1'-5"=11.33333 cu ft or 2'x4'x4"=2.6667 cu ft.

I have excel 2003 is it possible to do this and if not why these are basic
math. Also don't see any formulas that are geared towards the construction
industry. Is there an add on I can download?


Hi. Another way might be to simulate the use of Units.
One way would be to assume a default unit of "Ft"
Then, add a name range, say "In" with a value of 1/12.

A1: 2
B1: 4
C1: =1+5*In

C1 would be interpreted as 1 Ft, plus 5 Inch.

D1: =PRODUCT(A1:C1)
returns 11.3333

= = = = = = =
HTH :)
Dana DeLouis