how do i calculate 2' x 4' x 4"
in [Functions]
|
From: PlaceCarp on 3 Mar 2010 02:16 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?
From: Ron on 3 Mar 2010 02:26 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?
From: Jacob Skaria on 3 Mar 2010 02:34 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?
From: Bernard Liengme on 3 Mar 2010 08:10 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(a)discussions.microsoft.com> wrote in message news:87768050-908D-4C08-8EA3-F2BC39EC336C(a)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?
From: Dana DeLouis on 3 Mar 2010 09:17
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 |