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

  • Thread starter Thread starter PlaceCarp
  • Start date Start date
P

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?
 
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...
 
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
 
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?
Click to expand...


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
 
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
Click to expand...

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
 
Back
Top