Pressure Unit Converter in Excel
1 bar = 14.50377377 pound-force per square inch
Formula for this pair
These units are a straight multiple of each other. Put the starting value in cell A1.
=A1*14.50377377
Once you have saved the function below, type this in a cell
=ConvertPressure(1, "bar", "psi")
CONVERT
Excel's CONVERT function has no code for bar. Use the formula above. It uses this site's conversion factors.
How to save as a reusable Excel function
Microsoft 365. No VBA and no add-in.
- Open the function below and copy it. It has no call at the end.
- On the Formulas tab, choose Name Manager, then New.
- Set the name to ConvertPressure. Leave the scope as Workbook.
- Paste the function into Refers to.
- 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.
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.