Dynamic Viscosity Unit Converter in Excel
1 centipoise = 0.001 pascal second
Formula for this pair
These units are a straight multiple of each other. Put the starting value in cell A1.
=A1*0.001
Once you have saved the function below, type this in a cell
=ConvertDynamicViscosity(1, "cP", "Pa.s")
CONVERT
Excel's CONVERT function does not cover this quantity. 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 ConvertDynamicViscosity. Leave the scope as Workbook.
- Paste the function into Refers to.
- In a cell, type the call shown above.
ConvertDynamicViscosity
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"Pa.s",1,"EP",100000000000000000,"GP",100000000,"MP",100000,"N.s/m2",1,"P",0.1,"TP",100000000000,"cP",0.001,"dP",0.01,"dyne.s/cm2",0.1,"fP",1E-16,"kP",100,"kgf.s/m2",9.80665,"lbf.s/ft2",47.88025898033584,"lbf.s/in2",6894.757293168361,"mP",0.0001,"mPa.s",0.001,"nP",1E-10,"pP",1E-13,"psi.s",6894.757293168361,"uP",1E-7),fromShift,SWITCH(from_unit,"Pa.s",0,"EP",0,"GP",0,"MP",0,"N.s/m2",0,"P",0,"TP",0,"cP",0,"dP",0,"dyne.s/cm2",0,"fP",0,"kP",0,"kgf.s/m2",0,"lbf.s/ft2",0,"lbf.s/in2",0,"mP",0,"mPa.s",0,"nP",0,"pP",0,"psi.s",0,"uP",0),toFactor,SWITCH(to_unit,"Pa.s",1,"EP",100000000000000000,"GP",100000000,"MP",100000,"N.s/m2",1,"P",0.1,"TP",100000000000,"cP",0.001,"dP",0.01,"dyne.s/cm2",0.1,"fP",1E-16,"kP",100,"kgf.s/m2",9.80665,"lbf.s/ft2",47.88025898033584,"lbf.s/in2",6894.757293168361,"mP",0.0001,"mPa.s",0.001,"nP",1E-10,"pP",1E-13,"psi.s",6894.757293168361,"uP",1E-7),toShift,SWITCH(to_unit,"Pa.s",0,"EP",0,"GP",0,"MP",0,"N.s/m2",0,"P",0,"TP",0,"cP",0,"dP",0,"dyne.s/cm2",0,"fP",0,"kP",0,"kgf.s/m2",0,"lbf.s/ft2",0,"lbf.s/in2",0,"mP",0,"mPa.s",0,"nP",0,"pP",0,"psi.s",0,"uP",0),(value*fromFactor+fromShift-toShift)/toFactor))
Conversion factors
The factors this converter uses. Copy them into Excel as tab-separated values.
| Symbol | Name | Factor | Excel code |
|---|---|---|---|
| Pa.s | pascal second | 1 | — |
| EP | exapoise | 100000000000000000 | — |
| GP | gigapoise | 100000000 | — |
| MP | megapoise | 100000 | — |
| N.s/m2 | newton second per square metre | 1 | — |
| P | poise | 0.1 | — |
| TP | terapoise | 100000000000 | — |
| cP | centipoise | 0.001 | — |
| dP | decipoise | 0.01 | — |
| dyne.s/cm2 | dyne second per square centimetre | 0.1 | — |
| fP | femtopoise | 1E-16 | — |
| kP | kilopoise | 100 | — |
| kgf.s/m2 | thousand gram-force second per square metre | 9.80665 | — |
| lbf.s/ft2 | pound-force second per square foot | 47.88025898033584 | — |
| lbf.s/in2 | pound-force second per square inch | 6894.757293168361 | — |
| mP | millipoise | 0.0001 | — |
| mPa.s | millipascal second | 0.001 | — |
| nP | nanopoise | 1E-10 | — |
| pP | picopoise | 1E-13 | — |
| psi.s | psi second | 6894.757293168361 | — |
| uP | micropoise | 1E-7 | — |
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.