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.

  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 ConvertDynamicViscosity. Leave the scope as Workbook.
  4. Paste the function into Refers to.
  5. 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 FactorExcel 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.

Related