MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

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

• Follow

```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
```
 0
Reply Utf 3/3/2010 7:16:01 AM

```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?
```
 0
Reply Utf 3/3/2010 7:26:01 AM

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

--
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?
```
 0
Reply Utf 3/3/2010 7:34:01 AM

```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" <PlaceCarp@discussions.microsoft.com> wrote in message
news:87768050-908D-4C08-8EA3-F2BC39EC336C@microsoft.com...
> 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?

```
 0
Reply Bernard 3/3/2010 1:10:03 PM

```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
```
 0
Reply Dana 3/3/2010 2:17:21 PM

```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
```
 0
Reply Dana 3/3/2010 3:55:10 PM

5 Replies
223 Views

(page loaded in 0.119 seconds)

Similiar Articles:

7/23/2012 2:32:29 AM