Volume Ratios Unit Converter in Excel
5.614583333
Add-in Formula
=PO.UnitConverter(1, "m3/m3", "SCF/STB")
Excel Lambda
=LAMBDA(x,
LET(
ratio, 5.61458333333333,
x * ratio
)
)(1)
Category Lambda
=LAMBDA(x, from, to,
LET(
f, SWITCH(from,
"m3/m3", 1,
"SM3/SM3", 1,
"SCF/STB", 0.178107606679035,
"MSCF/STB", 178.107606679035,
"STB/SCF", 5.61458333333333,
"STB/MSCF", 0.00561458333333333),
t, SWITCH(to,
"m3/m3", 1,
"SM3/SM3", 1,
"SCF/STB", 0.178107606679035,
"MSCF/STB", 178.107606679035,
"STB/SCF", 5.61458333333333,
"STB/MSCF", 0.00561458333333333),
x * f / t
)
)(1, "m3/m3", "SCF/STB")
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.
ConvertVolumeRatios - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =ConvertVolumeRatios(1, "m3/m3", "SCF/STB")
anywhere in your workbook — no add-in required.
Conversion Factors (base: m3/m3)
| Unit | Name | Factor |
|---|---|---|
| m3/m3 | cubic metre per cubic metre | 1 |
| SM3/SM3 | standard cubic metre per standard cubic metre | 1 |
| SCF/STB | standard cubic foot per stock tank barrel | 0.178107606679035 |
| MSCF/STB | thousand standard cubic feet per stock tank barrel | 178.107606679035 |
| STB/SCF | stock tank barrel per standard cubic foot | 5.61458333333333 |
| STB/MSCF | stock tank barrel per thousand standard cubic feet | 0.00561458333333333 |