Moment Of Force Unit Converter in Excel

1 decinewton metre = 0.07375621493 foot pound-force

Formula for this pair

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

=A1*0.07375621493

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

=ConvertMomentOfForce(1, "dN.m", "lbf.ft")

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 ConvertMomentOfForce. Leave the scope as Workbook.
  4. Paste the function into Refers to.
  5. In a cell, type the call shown above.

ConvertMomentOfForce

Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"N.m",1,"1000 lbf.ft",1355.8179483314004,"dN.m",0.1,"daN.m",10,"kN.m",1000,"kgf.m",9.80665,"lbf.ft",1.3558179483314003,"lbf.in",0.1129848290276167,"lbm.ft2/s2",0.0421401100938048,"pdl.ft",0.0421401100938048,"tonf[US].ft",2711.635896662801,"tonf[US].mi",14317437.534379588),fromShift,SWITCH(from_unit,"N.m",0,"1000 lbf.ft",0,"dN.m",0,"daN.m",0,"kN.m",0,"kgf.m",0,"lbf.ft",0,"lbf.in",0,"lbm.ft2/s2",0,"pdl.ft",0,"tonf[US].ft",0,"tonf[US].mi",0),toFactor,SWITCH(to_unit,"N.m",1,"1000 lbf.ft",1355.8179483314004,"dN.m",0.1,"daN.m",10,"kN.m",1000,"kgf.m",9.80665,"lbf.ft",1.3558179483314003,"lbf.in",0.1129848290276167,"lbm.ft2/s2",0.0421401100938048,"pdl.ft",0.0421401100938048,"tonf[US].ft",2711.635896662801,"tonf[US].mi",14317437.534379588),toShift,SWITCH(to_unit,"N.m",0,"1000 lbf.ft",0,"dN.m",0,"daN.m",0,"kN.m",0,"kgf.m",0,"lbf.ft",0,"lbf.in",0,"lbm.ft2/s2",0,"pdl.ft",0,"tonf[US].ft",0,"tonf[US].mi",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
N.m newton metre 1—
1000 lbf.ft thousand foot pound-force 1355.8179483314004—
dN.m decinewton metre 0.1—
daN.m dekanewton metre 10—
kN.m kilonewton metre 1000—
kgf.m thousand gram-force metre 9.80665—
lbf.ft foot pound-force 1.3558179483314003—
lbf.in inch pound-force 0.1129848290276167—
lbm.ft2/s2 pound-mass square foot per second squared 0.0421401100938048—
pdl.ft foot poundal 0.0421401100938048—
tonf[US].ft US ton-force foot 2711.635896662801—
tonf[US].mi US ton-force mile 14317437.534379588—

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