Volume Unit Converter in Excel
7758.398381
Add-in Formula
=PO.UnitConverter(1, "acre.ft", "bbl")
Excel Lambda
=LAMBDA(x,
LET(
ratio, 7758.39838050126,
x * ratio
)
)(1)
Category Lambda
=LAMBDA(x, from, to,
LET(
f, SWITCH(from,
"bbl", 0.158987294928,
"mbbl", 158.987294928,
"mmbbl", 158987.294928,
"ft3", 0.028316846592,
"scf", 0.028316846592,
"mscf", 28.316846592,
"mmscf", 28316.846592,
"bcf", 28316846.592,
"m3", 1,
"E3m3", 1000,
"E6m3", 1000000,
"km3", 1000000000,
"dm3", 0.001,
"cm3", 1E-06,
"mm3", 1E-09,
"mi3", 4168181825.44058,
"yd3", 0.764554857984,
"in3", 1.6387064E-05,
"l", 0.001,
"ml", 1E-06,
"gal", 0.003785411784,
"acre.ft", 1233.48677148967),
t, SWITCH(to,
"bbl", 0.158987294928,
"mbbl", 158.987294928,
"mmbbl", 158987.294928,
"ft3", 0.028316846592,
"scf", 0.028316846592,
"mscf", 28.316846592,
"mmscf", 28316.846592,
"bcf", 28316846.592,
"m3", 1,
"E3m3", 1000,
"E6m3", 1000000,
"km3", 1000000000,
"dm3", 0.001,
"cm3", 1E-06,
"mm3", 1E-09,
"mi3", 4168181825.44058,
"yd3", 0.764554857984,
"in3", 1.6387064E-05,
"l", 0.001,
"ml", 1E-06,
"gal", 0.003785411784,
"acre.ft", 1233.48677148967),
x * f / t
)
)(1, "acre.ft", "bbl")
How to save as a reusable Excel function
LAMBDA is a built-in Excel feature (Microsoft 365) that lets you create custom functions without VBA. The formulas above work as-is when pasted into a cell.
To save a LAMBDA as a reusable named function:
- Go to Formulas → Name Manager → New
- Enter a name, e.g.
ConvertVolume - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =ConvertVolume(1, "acre.ft", "bbl")
anywhere in your workbook — no add-in required.
Conversion Factors (base: m3)
| Unit | Name | Factor |
|---|---|---|
| m3 | cubic metre | 1 |
| bbl | barrel | 0.158987294928 |
| mbbl | thousand oil barrels | 158.987294928 |
| mmbbl | million oil barrels | 158987.294928 |
| ft3 | cubic foot | 0.028316846592 |
| 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 |
| E3m3 | thousand cubic metre | 1000 |
| E6m3 | million cubic metre | 1000000 |
| km3 | cubic kilometre | 1000000000 |
| dm3 | cubic decimetre | 0.001 |
| cm3 | cubic centimetre | 1E-06 |
| mm3 | cubic millimetre | 1E-09 |
| mi3 | cubic mile | 4168181825.44058 |
| yd3 | cubic yard | 0.764554857984 |
| in3 | cubic inch | 1.6387064E-05 |
| l | litre | 0.001 |
| ml | millilitre | 1E-06 |
| gal | US gallon | 0.003785411784 |
| acre.ft | acre foot | 1233.48677148967 |