Excel 2003, how to convert gallons to cubic feet?

[Petec]

When using Excel 2003, what is the formula to convert gallons to cubic feet?

 

[MartinW]

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

 

[Sheeloo]

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

 

[Dave Peterson]

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.

 

[Shane Devenshire]

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.

 

[Ron Rosenfeld]

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

 

[Ron Rosenfeld]

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