Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003, how to convert gallons to cubic feet?
When using Excel 2003, what is the formula to convert gallons to cubic feet?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003, how to convert gallons to cubic feet?
Hi Pete,
You can take a look at the CONVERT function in the help file, however I don't think that will do it for you. You can just do it manually, here are the conversion factors from Google. 1 US gallon = 0.133680556 cubic feet 1 Imperial gallon = 0.16054372 cubic feet HTH Martin "Petec" wrote in message ... When using Excel 2003, what is the formula to convert gallons to cubic feet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003, how to convert gallons to cubic feet?
One (US) Gallon is 0.13368 Cubic Feet
So if you have Gallons in A1 use this in B1 =A1*0.13368 to convert into Cubic Feet "Petec" wrote: When using Excel 2003, what is the formula to convert gallons to cubic feet? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003, how to convert gallons to cubic feet?
Go to google.com and type this in the search box:
1 gallon to cubic feet And you'll see the factor you'll need. If A1 holds the number of gallons, you can use =a1*(that factor from google) In another cell. Petec wrote: When using Excel 2003, what is the formula to convert gallons to cubic feet? -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003, how to convert gallons to cubic feet?
Hi,
CONVERT does not have this option. You haven't specified what type of gallons, or ft you are working with. Here are some of the factors 1 dry US gallon = 0.155557002314815 international cubic feet 1 dry US gallon = 0.155556068975003 US Survey cubic feet 1 UK gallon = 0.160543653235892 international cubic feet 1 UK gallon = 0.160542689976245 US Survey cubic feet These number come from an Excel app I create and are based on many highly reliable sources. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Petec" wrote: When using Excel 2003, what is the formula to convert gallons to cubic feet? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003, how to convert gallons to cubic feet?
On Tue, 3 Mar 2009 10:48:00 +1000, "MartinW" wrote:
Hi Pete, You can take a look at the CONVERT function in the help file, however I don't think that will do it for you. You can just do it manually, here are the conversion factors from Google. 1 US gallon = 0.133680556 cubic feet 1 Imperial gallon = 0.16054372 cubic feet HTH Martin Well, you *should* be able to do it using the CONVERT function and some math, but it comes up with an incorrect answer. =CONVERT((CONVERT(A1,"gal","l")*1000)^(1/3),"cm","ft")^3 The error is in the very first conversion. The problem is that the CONVERT function does not seem to properly convert gallons to liters (nor does it properly convert quarts to liters (unless MS is using a different standard). Of course, the error introduced is small, resulting in an Excel derived conversion factor of 0.133709643 rather than the 0.133680556 that seems to be correct. --ron |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003, how to convert gallons to cubic feet?
On Mon, 02 Mar 2009 21:43:25 -0500, Ron Rosenfeld
wrote: On Tue, 3 Mar 2009 10:48:00 +1000, "MartinW" wrote: Hi Pete, You can take a look at the CONVERT function in the help file, however I don't think that will do it for you. You can just do it manually, here are the conversion factors from Google. 1 US gallon = 0.133680556 cubic feet 1 Imperial gallon = 0.16054372 cubic feet HTH Martin Well, you *should* be able to do it using the CONVERT function and some math, but it comes up with an incorrect answer. =CONVERT((CONVERT(A1,"gal","l")*1000)^(1/3),"cm","ft")^3 The error is in the very first conversion. The problem is that the CONVERT function does not seem to properly convert gallons to liters (nor does it properly convert quarts to liters (unless MS is using a different standard). Of course, the error introduced is small, resulting in an Excel derived conversion factor of 0.133709643 rather than the 0.133680556 that seems to be correct. --ron Just to elaborate, MS acknowledged the liter<--quart error many years ago, and last reviewed the KB article about 5 1/2 years ago. I wonder if they will ever get around to correcting it. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to convert decimal feet to feet inch sixteenths | Excel Discussion (Misc queries) | |||
can the "convert" function in excel convert to UK gallons? | Excel Discussion (Misc queries) | |||
Convert cubic centimeters to fluid ounces and cubic centimeters | Excel Worksheet Functions | |||
convert cubic centimeters to fluid ounces and cubic centimeters | Excel Worksheet Functions | |||
How do I convert cubic centimeters to ounces in Excel? | Excel Worksheet Functions |