Density Unit Converter in Excel
1000
Add-in Formula
=PO.UnitConverter(1, "g/cm3", "kg/m3")
Excel Lambda
=LAMBDA(x,
LET(
ratio, 1000,
x * ratio
)
)(1)
Category Lambda
=LAMBDA(x, from, to,
LET(
f, SWITCH(from,
"kg/m3", 1,
"g/cm3", 1000,
"lbm/ft3", 16.0184633739601),
t, SWITCH(to,
"kg/m3", 1,
"g/cm3", 1000,
"lbm/ft3", 16.0184633739601),
x * f / t
)
)(1, "g/cm3", "kg/m3")
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.
ConvertDensity - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =ConvertDensity(1, "g/cm3", "kg/m3")
anywhere in your workbook — no add-in required.
Conversion Factors (base: kg/m3)
| Unit | Name | Factor |
|---|---|---|
| kg/m3 | kilogram per cubic metre | 1 |
| g/cm3 | gram per cubic centimetre | 1000 |
| lbm/ft3 | pound-mass per cubic foot | 16.0184633739601 |