how do i calculate 2' x 4' x 4"
in [Functions]
|
From: Dana DeLouis on 3 Mar 2010 10:55 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 |