Compressibility Unit Converter in Excel
1.000000E-005
Add-in Formula
=PO.UnitConverter(1, "1/bar", "1/Pa")
Excel Lambda
=LAMBDA(x,
LET(
ratio, 1E-05,
x * ratio
)
)(1)
Category Lambda
=LAMBDA(x, from, to,
LET(
f, SWITCH(from,
"1/psi", 0.000145037737730209,
"1/atm", 9.86923266716013E-06,
"1/Pa", 1,
"1/bar", 1E-05),
t, SWITCH(to,
"1/psi", 0.000145037737730209,
"1/atm", 9.86923266716013E-06,
"1/Pa", 1,
"1/bar", 1E-05),
x * f / t
)
)(1, "1/bar", "1/Pa")
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.
ConvertCompressibility - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =ConvertCompressibility(1, "1/bar", "1/Pa")
anywhere in your workbook — no add-in required.
Conversion Factors (base: 1/Pa)
| Unit | Name | Factor |
|---|---|---|
| 1/Pa | per pascal | 1 |
| 1/psi | per psi | 0.000145037737730209 |
| 1/atm | per standard atmosphere | 9.86923266716013E-06 |
| 1/bar | per bar | 1E-05 |