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?

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


"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?

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 ToolsAddIns 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...

--
Jacob


"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?

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"PlaceCarp" wrote in message
...
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?

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

On 3/3/2010 9:17 AM, Dana DeLouis wrote:
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

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