Pressure Unit Converter in Excel
1000
Add-in Formula
=PO.UnitConverter(1, "bar", "hPa")
Excel Lambda
=LAMBDA(x,
LET(
ratio, 1000,
x * ratio
)
)(1)
Category Lambda
=LAMBDA(x, from, to,
LET(
f, SWITCH(from,
"Pa", 1,
"hPa", 100,
"kPa", 1000,
"MPa", 1000000,
"at", 98066.5,
"atm", 101325,
"bar", 100000,
"psi", 6894.75729316836,
"kgf/m2", 9.80665,
"kgf/cm2", 98066.5,
"kgf/mm2", 9806650),
t, SWITCH(to,
"Pa", 1,
"hPa", 100,
"kPa", 1000,
"MPa", 1000000,
"at", 98066.5,
"atm", 101325,
"bar", 100000,
"psi", 6894.75729316836,
"kgf/m2", 9.80665,
"kgf/cm2", 98066.5,
"kgf/mm2", 9806650),
x * f / t
)
)(1, "bar", "hPa")
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.
ConvertPressure - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =ConvertPressure(1, "bar", "hPa")
anywhere in your workbook — no add-in required.
Conversion Factors (base: Pa)
| Unit | Name | Factor |
|---|---|---|
| Pa | pascal | 1 |
| hPa | hectopascal | 100 |
| kPa | kilopascal | 1000 |
| MPa | megapascal | 1000000 |
| at | technical atmosphere | 98066.5 |
| atm | standard atmosphere | 101325 |
| bar | bar | 100000 |
| psi | pound-force per square inch | 6894.75729316836 |
| kgf/m2 | thousand gram-force per square metre | 9.80665 |
| kgf/cm2 | thousand gram-force per square centimetre | 98066.5 |
| kgf/mm2 | thousand gram-force per square millimetre | 9806650 |