Force Unit Converter in Excel
1 pound-force = 4.448221615E-018 exanewton
Formula for this pair
These units are a straight multiple of each other. Put the starting value in cell A1.
=A1*4.448221615E-018
Once you have saved the function below, type this in a cell
=ConvertForce(1, "lbf", "EN")
CONVERT
Paste this into a cell. Excel's CONVERT function knows both of these units.
=CONVERT(1, "lbf", "EN")
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 ConvertForce. Leave the scope as Workbook.
- Paste the function into Refers to.
- 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 | Factor | Excel code |
|---|---|---|---|
| N | newton | 1 | N |
| 10 kN | ten kilonewton | 10000 | — |
| EN | exanewton | 1000000000000000000 | EN |
| GN | giganewton | 1000000000 | GN |
| MN | meganewton | 1000000 | MN |
| Mgf | million gram-force | 9806.65 | — |
| TN | teranewton | 1000000000000 | TN |
| cN | centinewton | 0.01 | cN |
| dN | decinewton | 0.1 | dN |
| daN | dekanewton | 10 | daN |
| dyne | dyne | 0.00001 | dyn |
| fN | femtonewton | 1E-15 | fN |
| gf | gram-force | 0.00980665 | — |
| hN | hectonewton | 100 | hN |
| kN | kilonewton | 1000 | kN |
| kdyne | kilodyne | 0.01 | kdyn |
| kgf | thousand gram-force | 9.80665 | — |
| klbf | thousand pound-force | 4448.2216152605 | — |
| lbf | pound-force | 4.4482216152605 | lbf |
| mN | millinewton | 0.001 | mN |
| nN | nanonewton | 1E-9 | nN |
| ozf | ounce-force | 0.2780138509537812 | — |
| pN | piconewton | 1E-12 | pN |
| pdl | poundal | 0.138254954376 | — |
| tonf[UK] | UK ton-force | 9964.01641818352 | — |
| tonf[US] | US ton-force | 8896.443230521 | — |
| uN | micronewton | 0.000001 | uN |
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.