how do i calculate 2' x 4' x 4"

[PlaceCarp]

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?

 

[Ron@Buy]

Try this:
http://josh.com/InchCalc/index.htm

 

[Jacob Skaria]

Check out help on the function CONVERT() WHICH converts a number from one
measurement system to another. If this function is not available, and returns
the #NAME? error, install and load the Analysis ToolPak add-in. To install;
from menu Tools>AddIns> check 'Analysis ToolPak' and hit OK.

A1 = 2 (ft)
A2 = 4 (ft)
A3 = 4 (inches)

cubic feet would be
=A1*A2*CONVERT(A3,"in","ft")

If you have entires made in this format (1'-5") in a cell; you might need to
use additional functions like LEFT() SEARCH() and SUBSITUTE() to extract the
numeric portion of the string to feed into CONVERT() function...

 

[Bernard Liengme]

Suppose you have entered the three values (2,4,3) in A1, A2, A3
In A4 use =A1*A2*A3 to get the answer of 24 cubic feet

Now type these values into a1:A3:
A1 type 2 5/12 (with a gap between the 2 and the 5) standing fro 2 feet 5
inches
A2 type 3 6/12
A3 type 4 1/12
Note how A2 displays 3 1/2 but you could learn how to give al the cells a
custom format of # ??/12 so that they will always display 12th for inches

best wishes

 

[Dana DeLouis]

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

 

[Dana DeLouis]

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

Just to mention, if you added a name formula for Meters also, one could
place in C1 something like
=2*m+3.4*In

which would be a length of 2 Meters plus 3.4 inches.

The solution would be in cubic feet in D1.
There are many variations along this theme. :>)

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