Electric Resistance Unit Converter in Excel

From To

0.1

Add-in Formula =PO.UnitConverter(1, "cohm", "dohm")

Excel Lambda

=LAMBDA(x,
  LET(
    ratio, 0.1,
    x * ratio
  )
)(1)

Category Lambda

=LAMBDA(x, from, to,
  LET(
    f, SWITCH(from,
      "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-09,
      "pohm", 1E-12,
      "uohm", 1E-06),
    t, SWITCH(to,
      "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-09,
      "pohm", 1E-12,
      "uohm", 1E-06),
    x * f / t
  )
)(1, "cohm", "dohm")

How to save as a reusable Excel function

LAMBDA is a built-in Excel feature (Microsoft 365) that lets you create custom functions without VBA. The formulas above work as-is when pasted into a cell.

To save a LAMBDA as a reusable named function:

Go to Formulas → Name Manager → New
Enter a name, e.g. ConvertElectricResistance
In Refers to, paste the LAMBDA formula without the trailing invocation (...)
Click OK

Now use =ConvertElectricResistance(1, "cohm", "dohm") anywhere in your workbook — no add-in required.

Conversion Factors (base: ohm)

Unit	Name	Factor
ohm	ohm	1
Eohm	exaohm	1000000000000000000
Gohm	gigaohm	1000000000
Mohm	megohm	1000000
Tohm	teraohm	1000000000000
cohm	centiohm	0.01
dohm	deciohm	0.1
fohm	femtoohm	1E-15
kohm	kilohm	1000
mohm	milliohm	0.001
nohm	nanoohm	1E-09
pohm	picoohm	1E-12
uohm	microohm	1E-06