Moment Of Force Unit Converter in Excel
1 foot poundal = 0.3729714021 inch pound-force
Formula for this pair
These units are a straight multiple of each other. Put the starting value in cell A1.
=A1*0.3729714021
Once you have saved the function below, type this in a cell
=ConvertMomentOfForce(1, "pdl.ft", "lbf.in")
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 ConvertMomentOfForce. Leave the scope as Workbook.
- Paste the function into Refers to.
- 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 | Factor | Excel 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.