Pressure Unit Converter in Excel

1 pound-force per square inch = 6894757.293 millipascal

Formula for this pair

These units are a straight multiple of each other. Put the starting value in cell A1.

=A1*6894757.293

Once you have saved the function below, type this in a cell

=ConvertPressure(1, "psi", "mPa")

CONVERT

Paste this into a cell. Excel's CONVERT function knows both of these units.

=CONVERT(1, "psi", "mPa")

How to save as a reusable Excel function

Microsoft 365. No VBA and no add-in.

  1. Open the function below and copy it. It has no call at the end.
  2. On the Formulas tab, choose Name Manager, then New.
  3. Set the name to ConvertPressure. Leave the scope as Workbook.
  4. Paste the function into Refers to.
  5. In a cell, type the call shown above.

ConvertPressure

Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"Pa",1,"0.01 lbf/ft2",0.4788025898033583,"EPa",1000000000000000000,"GPa",1000000000,"MPa",1000000,"Mpsi",6894757293.168363,"N/m2",1,"N/mm2",1000000,"TPa",1000000000000,"at",98066.5,"atm",101325,"bar",100000,"cPa",0.01,"cmH2O[4degC]",98.0638,"dPa",0.1,"dyne/cm2",0.1,"fPa",1E-15,"hbar",10000000,"inH2O[39degF]",249.082,"inH2O[60degF]",248.84,"inHg[32degF]",3386.38,"inHg[60degF]",3376.85,"kN/m2",1000,"kPa",1000,"kgf/cm2",98066.5,"kgf/m2",9.80665,"kgf/mm2",9806650,"kpsi",6894757.293168361,"lbf/ft2",47.88025898033584,"mPa",0.001,"mbar",100,"mmHg[0degC]",133.322,"nPa",1E-9,"pPa",1E-12,"psi",6894.757293168361,"tonf[UK]/ft2",107251.7801159523,"tonf[US]/ft2",95760.51796067167,"tonf[US]/in2",13789514.586336723,"torr",133.32236842105263,"uPa",0.000001,"ubar",0.1,"umHg[0degC]",0.133322,"upsi",0.006894757293168362,"hPa",100),fromShift,SWITCH(from_unit,"Pa",0,"0.01 lbf/ft2",0,"EPa",0,"GPa",0,"MPa",0,"Mpsi",0,"N/m2",0,"N/mm2",0,"TPa",0,"at",0,"atm",0,"bar",0,"cPa",0,"cmH2O[4degC]",0,"dPa",0,"dyne/cm2",0,"fPa",0,"hbar",0,"inH2O[39degF]",0,"inH2O[60degF]",0,"inHg[32degF]",0,"inHg[60degF]",0,"kN/m2",0,"kPa",0,"kgf/cm2",0,"kgf/m2",0,"kgf/mm2",0,"kpsi",0,"lbf/ft2",0,"mPa",0,"mbar",0,"mmHg[0degC]",0,"nPa",0,"pPa",0,"psi",0,"tonf[UK]/ft2",0,"tonf[US]/ft2",0,"tonf[US]/in2",0,"torr",0,"uPa",0,"ubar",0,"umHg[0degC]",0,"upsi",0,"hPa",0),toFactor,SWITCH(to_unit,"Pa",1,"0.01 lbf/ft2",0.4788025898033583,"EPa",1000000000000000000,"GPa",1000000000,"MPa",1000000,"Mpsi",6894757293.168363,"N/m2",1,"N/mm2",1000000,"TPa",1000000000000,"at",98066.5,"atm",101325,"bar",100000,"cPa",0.01,"cmH2O[4degC]",98.0638,"dPa",0.1,"dyne/cm2",0.1,"fPa",1E-15,"hbar",10000000,"inH2O[39degF]",249.082,"inH2O[60degF]",248.84,"inHg[32degF]",3386.38,"inHg[60degF]",3376.85,"kN/m2",1000,"kPa",1000,"kgf/cm2",98066.5,"kgf/m2",9.80665,"kgf/mm2",9806650,"kpsi",6894757.293168361,"lbf/ft2",47.88025898033584,"mPa",0.001,"mbar",100,"mmHg[0degC]",133.322,"nPa",1E-9,"pPa",1E-12,"psi",6894.757293168361,"tonf[UK]/ft2",107251.7801159523,"tonf[US]/ft2",95760.51796067167,"tonf[US]/in2",13789514.586336723,"torr",133.32236842105263,"uPa",0.000001,"ubar",0.1,"umHg[0degC]",0.133322,"upsi",0.006894757293168362,"hPa",100),toShift,SWITCH(to_unit,"Pa",0,"0.01 lbf/ft2",0,"EPa",0,"GPa",0,"MPa",0,"Mpsi",0,"N/m2",0,"N/mm2",0,"TPa",0,"at",0,"atm",0,"bar",0,"cPa",0,"cmH2O[4degC]",0,"dPa",0,"dyne/cm2",0,"fPa",0,"hbar",0,"inH2O[39degF]",0,"inH2O[60degF]",0,"inHg[32degF]",0,"inHg[60degF]",0,"kN/m2",0,"kPa",0,"kgf/cm2",0,"kgf/m2",0,"kgf/mm2",0,"kpsi",0,"lbf/ft2",0,"mPa",0,"mbar",0,"mmHg[0degC]",0,"nPa",0,"pPa",0,"psi",0,"tonf[UK]/ft2",0,"tonf[US]/ft2",0,"tonf[US]/in2",0,"torr",0,"uPa",0,"ubar",0,"umHg[0degC]",0,"upsi",0,"hPa",0),(value*fromFactor+fromShift-toShift)/toFactor))

Conversion factors

The factors this converter uses. Copy them into Excel as tab-separated values.

Symbol Name FactorExcel code
Pa pascal 1Pa
0.01 lbf/ft2 pound-force per hundred square foot 0.4788025898033583—
EPa exapascal 1000000000000000000EPa
GPa gigapascal 1000000000GPa
MPa megapascal 1000000MPa
Mpsi million psi 6894757293.168363—
N/m2 newton per square metre 1—
N/mm2 newton per square millimetre 1000000—
TPa terapascal 1000000000000TPa
at technical atmosphere 98066.5—
atm standard atmosphere 101325atm
bar bar 100000—
cPa centipascal 0.01cPa
cmH2O[4degC] centimetre of water at 4 degree Celsius 98.0638—
dPa decipascal 0.1dPa
dyne/cm2 dyne per square centimetre 0.1—
fPa femtopascal 1E-15fPa
hbar hundred bar 10000000—
inH2O[39degF] inch of water at 39.2 degree Fahrenheit 249.082—
inH2O[60degF] inch of water at 60 degree Fahrenheit 248.84—
inHg[32degF] inch of mercury at 32 degree Fahrenheit 3386.38—
inHg[60degF] inch of mercury at 60 degree Fahrenheit 3376.85—
kN/m2 kilonewton per square metre 1000—
kPa kilopascal 1000kPa
kgf/cm2 thousand gram-force per square centimetre 98066.5—
kgf/m2 thousand gram-force per square metre 9.80665—
kgf/mm2 thousand gram-force per square millimetre 9806650—
kpsi thousand psi 6894757.293168361—
lbf/ft2 pound-force per square foot 47.88025898033584—
mPa millipascal 0.001mPa
mbar thousandth of bar 100—
mmHg[0degC] millimetres of Mercury at 0 deg C 133.322—
nPa nanopascal 1E-9nPa
pPa picopascal 1E-12pPa
psi pound-force per square inch 6894.757293168361psi
tonf[UK]/ft2 UK ton-force per square foot 107251.7801159523—
tonf[US]/ft2 US ton-force per square foot 95760.51796067167—
tonf[US]/in2 US ton-force per square inch 13789514.586336723—
torr torr 133.32236842105263Torr
uPa micropascal 0.000001uPa
ubar millionth of bar 0.1—
umHg[0degC] micrometre of mercury at 0 degree Celsius 0.133322—
upsi millionth of psi 0.006894757293168362—
hPa hectopascal 100hPa

Notes

Excel's code at is another name for the standard atmosphere (atm, 101,325 Pa). It is not the technical atmosphere, which this catalogue calls at (98,066.5 Pa). Bar has no CONVERT code. kN/m2 and N/mm2 do not either, even though the values equal kPa and MPa. A prefix on Pa does work, so kPa and MPa are valid. kPa to psi is a pair CONVERT can do.

Google Sheets

Google Sheets has CONVERT and many of the same codes, and it has LAMBDA. Named functions are created under Data > Named functions, not Formulas > Name Manager. A code that works in Excel can return #N/A in Sheets, so try a known value before you rely on it.

Related