Volume Unit Converter in Excel
1 litre = 1.759753986 UK pint
Formula for this pair
These units are a straight multiple of each other. Put the starting value in cell A1.
=A1*1.759753986
Once you have saved the function below, type this in a cell
=ConvertVolume(1, "l", "pt[UK]")
CONVERT
Paste this into a cell. Excel's CONVERT function knows both of these units.
=CONVERT(1, "l", "uk_pt")
How to save as a reusable Excel function
Microsoft 365. No VBA and no add-in.
- Open the function below and copy it. It has no call at the end.
- On the Formulas tab, choose Name Manager, then New.
- Set the name to ConvertVolume. Leave the scope as Workbook.
- Paste the function into Refers to.
- In a cell, type the call shown above.
ConvertVolume
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"m3",1,"1000 bbl",158.987294928,"1000 ft3",28.316846592,"1000 gal[UK]",4.54609,"1000 gal[US]",3.785411784,"1000 m3",1000,"E3m3",1000,"1E-6 gal[US]",3.785411784E-9,"1E12 ft3",28316846592,"1E6 bbl",158987.294928,"1E6 ft3",28316.846592,"1E6 m3",1000000,"E6m3",1000000,"1E9 bbl",158987294.928,"1E9 ft3",28316846.592,"L",0.001,"acre.ft",1233.486771489672,"bbl",0.158987294928,"cm3",0.000001,"dm3",0.001,"floz[UK]",0.0000284130625,"floz[US]",0.0000295735295625,"ft3",0.028316846592,"gal[UK]",0.00454609,"gal[US]",0.003785411784,"hL",0.1,"ha.m",10000,"in3",0.000016387064,"km3",1000000000,"mL",0.000001,"mi3",4168181825.4405794,"mm3",1E-9,"pt[UK]",0.00056826125,"pt[US]",0.000473176473,"qt[UK]",0.0011365225,"qt[US]",0.000946352946,"um2.m",1E-12,"yd3",0.764554857984,"SM3",1,"l",0.001,"ml",0.000001,"gal",0.003785411784,"mbbl",158.987294928,"mmbbl",158987.29492800002,"scf",0.028316846592,"mscf",28.316846592,"mmscf",28316.846592,"bcf",28316846.592,"STB",0.158987294928,"stb",0.158987294928,"BBL",0.158987294928,"MSTB",158.987294928,"mstb",158.987294928,"MMSTB",158987.29492800002,"mmstb",158987.29492800002,"SCF",0.028316846592,"MSCF",28.316846592,"MMSCF",28316.846592,"BCF",28316846.592,"cup[US]",0.0002365882365,"cup[UK]",0.000284130625,"cup[metric]",0.00025,"tbsp[US]",0.00001478676478125,"tbsp[UK]",0.00001420653125,"tbsp[metric]",0.000015,"tsp[US]",0.00000492892159375,"tsp[UK]",0.0000035516328125,"tsp[metric]",0.000005),fromShift,SWITCH(from_unit,"m3",0,"1000 bbl",0,"1000 ft3",0,"1000 gal[UK]",0,"1000 gal[US]",0,"1000 m3",0,"E3m3",0,"1E-6 gal[US]",0,"1E12 ft3",0,"1E6 bbl",0,"1E6 ft3",0,"1E6 m3",0,"E6m3",0,"1E9 bbl",0,"1E9 ft3",0,"L",0,"acre.ft",0,"bbl",0,"cm3",0,"dm3",0,"floz[UK]",0,"floz[US]",0,"ft3",0,"gal[UK]",0,"gal[US]",0,"hL",0,"ha.m",0,"in3",0,"km3",0,"mL",0,"mi3",0,"mm3",0,"pt[UK]",0,"pt[US]",0,"qt[UK]",0,"qt[US]",0,"um2.m",0,"yd3",0,"SM3",0,"l",0,"ml",0,"gal",0,"mbbl",0,"mmbbl",0,"scf",0,"mscf",0,"mmscf",0,"bcf",0,"STB",0,"stb",0,"BBL",0,"MSTB",0,"mstb",0,"MMSTB",0,"mmstb",0,"SCF",0,"MSCF",0,"MMSCF",0,"BCF",0,"cup[US]",0,"cup[UK]",0,"cup[metric]",0,"tbsp[US]",0,"tbsp[UK]",0,"tbsp[metric]",0,"tsp[US]",0,"tsp[UK]",0,"tsp[metric]",0),toFactor,SWITCH(to_unit,"m3",1,"1000 bbl",158.987294928,"1000 ft3",28.316846592,"1000 gal[UK]",4.54609,"1000 gal[US]",3.785411784,"1000 m3",1000,"E3m3",1000,"1E-6 gal[US]",3.785411784E-9,"1E12 ft3",28316846592,"1E6 bbl",158987.294928,"1E6 ft3",28316.846592,"1E6 m3",1000000,"E6m3",1000000,"1E9 bbl",158987294.928,"1E9 ft3",28316846.592,"L",0.001,"acre.ft",1233.486771489672,"bbl",0.158987294928,"cm3",0.000001,"dm3",0.001,"floz[UK]",0.0000284130625,"floz[US]",0.0000295735295625,"ft3",0.028316846592,"gal[UK]",0.00454609,"gal[US]",0.003785411784,"hL",0.1,"ha.m",10000,"in3",0.000016387064,"km3",1000000000,"mL",0.000001,"mi3",4168181825.4405794,"mm3",1E-9,"pt[UK]",0.00056826125,"pt[US]",0.000473176473,"qt[UK]",0.0011365225,"qt[US]",0.000946352946,"um2.m",1E-12,"yd3",0.764554857984,"SM3",1,"l",0.001,"ml",0.000001,"gal",0.003785411784,"mbbl",158.987294928,"mmbbl",158987.29492800002,"scf",0.028316846592,"mscf",28.316846592,"mmscf",28316.846592,"bcf",28316846.592,"STB",0.158987294928,"stb",0.158987294928,"BBL",0.158987294928,"MSTB",158.987294928,"mstb",158.987294928,"MMSTB",158987.29492800002,"mmstb",158987.29492800002,"SCF",0.028316846592,"MSCF",28.316846592,"MMSCF",28316.846592,"BCF",28316846.592,"cup[US]",0.0002365882365,"cup[UK]",0.000284130625,"cup[metric]",0.00025,"tbsp[US]",0.00001478676478125,"tbsp[UK]",0.00001420653125,"tbsp[metric]",0.000015,"tsp[US]",0.00000492892159375,"tsp[UK]",0.0000035516328125,"tsp[metric]",0.000005),toShift,SWITCH(to_unit,"m3",0,"1000 bbl",0,"1000 ft3",0,"1000 gal[UK]",0,"1000 gal[US]",0,"1000 m3",0,"E3m3",0,"1E-6 gal[US]",0,"1E12 ft3",0,"1E6 bbl",0,"1E6 ft3",0,"1E6 m3",0,"E6m3",0,"1E9 bbl",0,"1E9 ft3",0,"L",0,"acre.ft",0,"bbl",0,"cm3",0,"dm3",0,"floz[UK]",0,"floz[US]",0,"ft3",0,"gal[UK]",0,"gal[US]",0,"hL",0,"ha.m",0,"in3",0,"km3",0,"mL",0,"mi3",0,"mm3",0,"pt[UK]",0,"pt[US]",0,"qt[UK]",0,"qt[US]",0,"um2.m",0,"yd3",0,"SM3",0,"l",0,"ml",0,"gal",0,"mbbl",0,"mmbbl",0,"scf",0,"mscf",0,"mmscf",0,"bcf",0,"STB",0,"stb",0,"BBL",0,"MSTB",0,"mstb",0,"MMSTB",0,"mmstb",0,"SCF",0,"MSCF",0,"MMSCF",0,"BCF",0,"cup[US]",0,"cup[UK]",0,"cup[metric]",0,"tbsp[US]",0,"tbsp[UK]",0,"tbsp[metric]",0,"tsp[US]",0,"tsp[UK]",0,"tsp[metric]",0),(value*fromFactor+fromShift-toShift)/toFactor))
Conversion factors
The factors this converter uses. Copy them into Excel as tab-separated values.
| Symbol | Name | Factor | Excel code |
|---|---|---|---|
| m3 | cubic metre | 1 | m3 |
| 1000 bbl | thousand barrel | 158.987294928 | — |
| 1000 ft3 | thousand cubic foot | 28.316846592 | — |
| 1000 gal[UK] | thousand UK gallon | 4.54609 | — |
| 1000 gal[US] | thousand US gallon | 3.785411784 | — |
| 1000 m3 | thousand cubic metre | 1000 | — |
| E3m3 | thousand cubic metre | 1000 | — |
| 1E-6 gal[US] | millionth of US gallon | 3.785411784E-9 | — |
| 1E12 ft3 | million million cubic foot | 28316846592 | — |
| 1E6 bbl | million barrel | 158987.294928 | — |
| 1E6 ft3 | million cubic foot | 28316.846592 | — |
| 1E6 m3 | million cubic metre | 1000000 | — |
| E6m3 | million cubic metre | 1000000 | — |
| 1E9 bbl | thousand million barrel | 158987294.928 | — |
| 1E9 ft3 | thousand million cubic foot | 28316846.592 | — |
| L | litre | 0.001 | L |
| acre.ft | acre foot | 1233.486771489672 | — |
| bbl | barrel | 0.158987294928 | barrel |
| cm3 | cubic centimetre | 0.000001 | — |
| dm3 | cubic decimetre | 0.001 | — |
| floz[UK] | UK fluid-ounce | 0.0000284130625 | — |
| floz[US] | US fluid-ounce | 0.0000295735295625 | oz |
| ft3 | cubic foot | 0.028316846592 | ft3 |
| gal[UK] | UK gallon | 0.00454609 | uk_gal |
| gal[US] | US gallon | 0.003785411784 | gal |
| hL | hectolitre | 0.1 | hL |
| ha.m | hectare metre | 10000 | — |
| in3 | cubic inch | 0.000016387064 | in3 |
| km3 | cubic kilometre | 1000000000 | — |
| mL | millilitre | 0.000001 | mL |
| mi3 | cubic mile | 4168181825.4405794 | mi3 |
| mm3 | cubic millimetre | 1E-9 | — |
| pt[UK] | UK pint | 0.00056826125 | uk_pt |
| pt[US] | US pint | 0.000473176473 | pt |
| qt[UK] | UK quart | 0.0011365225 | uk_qt |
| qt[US] | US quart | 0.000946352946 | qt |
| um2.m | square micrometre metre | 1E-12 | — |
| yd3 | cubic yard | 0.764554857984 | yd3 |
| SM3 | standard cubic metre | 1 | — |
| l | litre | 0.001 | l |
| ml | millilitre | 0.000001 | ml |
| gal | US gallon | 0.003785411784 | gal |
| mbbl | thousand oil barrels | 158.987294928 | — |
| mmbbl | million oil barrels | 158987.29492800002 | — |
| scf | standard cubic foot | 0.028316846592 | — |
| mscf | thousand standard cubic feet | 28.316846592 | — |
| mmscf | million standard cubic feet | 28316.846592 | — |
| bcf | billion standard cubic feet | 28316846.592 | — |
| STB | stock tank barrel | 0.158987294928 | — |
| stb | stock tank barrel | 0.158987294928 | — |
| BBL | oil barrel | 0.158987294928 | barrel |
| MSTB | thousand stock tank barrels | 158.987294928 | — |
| mstb | thousand stock tank barrels | 158.987294928 | — |
| MMSTB | million stock tank barrels | 158987.29492800002 | — |
| mmstb | million stock tank barrels | 158987.29492800002 | — |
| SCF | oil standart cubic feet | 0.028316846592 | — |
| MSCF | thousand standard cubic feet | 28.316846592 | — |
| MMSCF | million standard cubic feet | 28316.846592 | — |
| BCF | billion standard cubic feet | 28316846.592 | — |
| cup[US] | US cup | 0.0002365882365 | cup |
| cup[UK] | imperial cup | 0.000284130625 | — |
| cup[metric] | metric cup | 0.00025 | — |
| tbsp[US] | US tablespoon | 0.00001478676478125 | tbs |
| tbsp[UK] | imperial tablespoon | 0.00001420653125 | — |
| tbsp[metric] | metric tablespoon | 0.000015 | — |
| tsp[US] | US teaspoon | 0.00000492892159375 | tsp |
| tsp[UK] | imperial teaspoon | 0.0000035516328125 | — |
| tsp[metric] | metric teaspoon | 0.000005 | tspm |
Notes
Excel's barrel is the US oil barrel of 42 US gallons. In this catalogue that is bbl and BBL, so both use the code barrel. A stock-tank barrel has the same factor here, but CONVERT has no stb code, and it has none for scf. A prefix on m3 scales the cubic metre: cm3 is not a cubic centimetre. One millilitre is one cubic centimetre, and that uses the litre code mL, not cm3.
Google Sheets
Google Sheets has CONVERT and many of the same codes, and it has LAMBDA. Named functions are created under Data > Named functions, not Formulas > Name Manager. A code that works in Excel can return #N/A in Sheets, so try a known value before you rely on it.