Electric Resistance Unit Converter in Excel
1 milliohm = 0.001 ohm
Formula for this pair
These units are a straight multiple of each other. Put the starting value in cell A1.
=A1*0.001
Once you have saved the function below, type this in a cell
=ConvertElectricResistance(1, "mohm", "ohm")
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 ConvertElectricResistance. Leave the scope as Workbook.
- Paste the function into Refers to.
- In a cell, type the call shown above.
ConvertElectricResistance
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"ohm",1,"Eohm",1000000000000000000,"Gohm",1000000000,"Mohm",1000000,"Tohm",1000000000000,"cohm",0.01,"dohm",0.1,"fohm",1E-15,"kohm",1000,"mohm",0.001,"nohm",1E-9,"pohm",1E-12,"uohm",0.000001),fromShift,SWITCH(from_unit,"ohm",0,"Eohm",0,"Gohm",0,"Mohm",0,"Tohm",0,"cohm",0,"dohm",0,"fohm",0,"kohm",0,"mohm",0,"nohm",0,"pohm",0,"uohm",0),toFactor,SWITCH(to_unit,"ohm",1,"Eohm",1000000000000000000,"Gohm",1000000000,"Mohm",1000000,"Tohm",1000000000000,"cohm",0.01,"dohm",0.1,"fohm",1E-15,"kohm",1000,"mohm",0.001,"nohm",1E-9,"pohm",1E-12,"uohm",0.000001),toShift,SWITCH(to_unit,"ohm",0,"Eohm",0,"Gohm",0,"Mohm",0,"Tohm",0,"cohm",0,"dohm",0,"fohm",0,"kohm",0,"mohm",0,"nohm",0,"pohm",0,"uohm",0),(value*fromFactor+fromShift-toShift)/toFactor))
Conversion factors
The factors this converter uses. Copy them into Excel as tab-separated values.
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.