Power Unit Converter in Excel
0.1
Add-in Formula
=PO.UnitConverter(1, "cW", "dW")
Excel Lambda
=LAMBDA(x,
LET(
ratio, 0.1,
x * ratio
)
)(1)
Category Lambda
=LAMBDA(x, from, to,
LET(
f, SWITCH(from,
"W", 1,
"EW", 1000000000000000000,
"GW", 1000000000,
"MW", 1000000,
"TW", 1000000000000,
"cW", 0.01,
"dW", 0.1,
"fW", 1E-15,
"hp", 745.69987158227,
"hp[elec]", 746,
"hp[hyd]", 746.043,
"hp[metric]", 735.49875,
"kW", 1000,
"mW", 0.001,
"nW", 1E-09,
"pW", 1E-12,
"tonRefrig", 3516.85284206667,
"uW", 1E-06),
t, SWITCH(to,
"W", 1,
"EW", 1000000000000000000,
"GW", 1000000000,
"MW", 1000000,
"TW", 1000000000000,
"cW", 0.01,
"dW", 0.1,
"fW", 1E-15,
"hp", 745.69987158227,
"hp[elec]", 746,
"hp[hyd]", 746.043,
"hp[metric]", 735.49875,
"kW", 1000,
"mW", 0.001,
"nW", 1E-09,
"pW", 1E-12,
"tonRefrig", 3516.85284206667,
"uW", 1E-06),
x * f / t
)
)(1, "cW", "dW")
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.
ConvertPower - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =ConvertPower(1, "cW", "dW")
anywhere in your workbook — no add-in required.
Conversion Factors (base: W)
| Unit | Name | Factor |
|---|---|---|
| W | watt | 1 |
| EW | exawatt | 1000000000000000000 |
| GW | gigawatt | 1000000000 |
| MW | megawatt | 1000000 |
| TW | terawatt | 1000000000000 |
| cW | centiwatt | 0.01 |
| dW | deciwatt | 0.1 |
| fW | femtowatt | 1E-15 |
| hp | horsepower | 745.69987158227 |
| hp[elec] | electric-horsepower | 746 |
| hp[hyd] | hydraulic-horsepower | 746.043 |
| hp[metric] | metric-horsepower | 735.49875 |
| kW | kilowatt | 1000 |
| mW | milliwatt | 0.001 |
| nW | nanowatt | 1E-09 |
| pW | picowatt | 1E-12 |
| tonRefrig | ton-refrigeration | 3516.85284206667 |
| uW | microwatt | 1E-06 |