Force Unit Converter in Excel

1 meganewton = 100000000 kilodyne

Formula for this pair

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

=A1*100000000

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

=ConvertForce(1, "MN", "kdyne")

CONVERT

Paste this into a cell. Excel's CONVERT function knows both of these units.

=CONVERT(1, "MN", "kdyn")

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

ConvertForce

Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"N",1,"10 kN",10000,"EN",1000000000000000000,"GN",1000000000,"MN",1000000,"Mgf",9806.65,"TN",1000000000000,"cN",0.01,"dN",0.1,"daN",10,"dyne",0.00001,"fN",1E-15,"gf",0.00980665,"hN",100,"kN",1000,"kdyne",0.01,"kgf",9.80665,"klbf",4448.2216152605,"lbf",4.4482216152605,"mN",0.001,"nN",1E-9,"ozf",0.2780138509537812,"pN",1E-12,"pdl",0.138254954376,"tonf[UK]",9964.01641818352,"tonf[US]",8896.443230521,"uN",0.000001),fromShift,SWITCH(from_unit,"N",0,"10 kN",0,"EN",0,"GN",0,"MN",0,"Mgf",0,"TN",0,"cN",0,"dN",0,"daN",0,"dyne",0,"fN",0,"gf",0,"hN",0,"kN",0,"kdyne",0,"kgf",0,"klbf",0,"lbf",0,"mN",0,"nN",0,"ozf",0,"pN",0,"pdl",0,"tonf[UK]",0,"tonf[US]",0,"uN",0),toFactor,SWITCH(to_unit,"N",1,"10 kN",10000,"EN",1000000000000000000,"GN",1000000000,"MN",1000000,"Mgf",9806.65,"TN",1000000000000,"cN",0.01,"dN",0.1,"daN",10,"dyne",0.00001,"fN",1E-15,"gf",0.00980665,"hN",100,"kN",1000,"kdyne",0.01,"kgf",9.80665,"klbf",4448.2216152605,"lbf",4.4482216152605,"mN",0.001,"nN",1E-9,"ozf",0.2780138509537812,"pN",1E-12,"pdl",0.138254954376,"tonf[UK]",9964.01641818352,"tonf[US]",8896.443230521,"uN",0.000001),toShift,SWITCH(to_unit,"N",0,"10 kN",0,"EN",0,"GN",0,"MN",0,"Mgf",0,"TN",0,"cN",0,"dN",0,"daN",0,"dyne",0,"fN",0,"gf",0,"hN",0,"kN",0,"kdyne",0,"kgf",0,"klbf",0,"lbf",0,"mN",0,"nN",0,"ozf",0,"pN",0,"pdl",0,"tonf[UK]",0,"tonf[US]",0,"uN",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 newton 1N
10 kN ten kilonewton 10000—
EN exanewton 1000000000000000000EN
GN giganewton 1000000000GN
MN meganewton 1000000MN
Mgf million gram-force 9806.65—
TN teranewton 1000000000000TN
cN centinewton 0.01cN
dN decinewton 0.1dN
daN dekanewton 10daN
dyne dyne 0.00001dyn
fN femtonewton 1E-15fN
gf gram-force 0.00980665—
hN hectonewton 100hN
kN kilonewton 1000kN
kdyne kilodyne 0.01kdyn
kgf thousand gram-force 9.80665—
klbf thousand pound-force 4448.2216152605—
lbf pound-force 4.4482216152605lbf
mN millinewton 0.001mN
nN nanonewton 1E-9nN
ozf ounce-force 0.2780138509537812—
pN piconewton 1E-12pN
pdl poundal 0.138254954376—
tonf[UK] UK ton-force 9964.01641818352—
tonf[US] US ton-force 8896.443230521—
uN micronewton 0.000001uN

Notes

The newton takes a prefix, so kN is a code. Pound-force is lbf. Dyne is dyn and kilodyne is kdyn. Kilogram-force, ounce-force and ton-force have no CONVERT code.

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