Second Moment Of Area Unit Converter in Excel
1 centimetre to the fourth power = 1.000000000E-008 metre to the fourth power
Formula for this pair
These units are a straight multiple of each other. Put the starting value in cell A1.
=A1*1.000000000E-008
Once you have saved the function below, type this in a cell
=ConvertSecondMomentOfArea(1, "cm4", "m4")
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 ConvertSecondMomentOfArea. Leave the scope as Workbook.
- Paste the function into Refers to.
- In a cell, type the call shown above.
ConvertSecondMomentOfArea
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"m4",1,"cm4",1E-8,"in4",4.162314256E-7),fromShift,SWITCH(from_unit,"m4",0,"cm4",0,"in4",0),toFactor,SWITCH(to_unit,"m4",1,"cm4",1E-8,"in4",4.162314256E-7),toShift,SWITCH(to_unit,"m4",0,"cm4",0,"in4",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 |
|---|---|---|---|
| m4 | metre to the fourth power | 1 | — |
| cm4 | centimetre to the fourth power | 1E-8 | — |
| in4 | inch to the fourth power | 4.162314256E-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.