Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Formula for Cubic ft to US Gallons

Copper Contributor

any one know a formula for the conversion of cubic ft to US Gallons?

3 Replies

@CremeStout 

 

=CONVERT(37,"ft^3","gal")

 

Instead of the fixed value 37 you can use a cell reference, of course.

ty however the "ft... ....) section i am not able figure out .
i know there are 7.5 gal in a ft cube so maybe i just do division
so you got me thinking

@CremeStout 

 

"ft^3" stands for "foot to the third power", in other words, cubic feet.

The conversion factor is 7.48052