ToUSLiquidGallon ( Quantity ; Unit )

Convert input to US liquid gallons

Average rating: 4.4 (31 votes) Log in to vote

Geoff Wells
DataIsland Software LLC
http://www.dataisland.com

Sample input:

ToUSLiquidGallon ( 9; "Firkin" )

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Case (

Unit = "Quart" ; Quantity * .25;

Unit = "Pint" ; Quantity * .125;

Unit = "UKGallon" ; Quantity * 1.200949925;

Unit = "UKPint" ; Quantity * .150118741;

Unit = "UKQuart" ; Quantity * .300237481;

Unit = "Litre" ; Quantity * .264172052;

Unit = "BarrelOil" ; Quantity * 42;

Unit = "Bushel" ; Quantity * 9.309177482;

Unit = "CubicFeet" ; Quantity * 7.480519478;

Unit = "CubicMeter" ; Quantity * 264.17205;

Unit = "USDry" ; Quantity * 1.163647185;

Unit = "Gill" ; Quantity * .03125;

Unit = "Firkin" ; Quantity * 9;

Quantity

)

Supply this function with a variety of liquid measurements and they will be converted to US gallons.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ToUSLiquidGallon ( Quantity ; Unit )

Comments

Support this website.

Support this website.