Temperature Unit Converter in Excel
33.8
Add-in Formula
=PO.UnitConverter(1, "degC", "degF")
Excel Lambda
=LAMBDA(x,
LET(
base, x * 1 + 273.15,
(base - 255.372222222222) / 0.555555555555556
)
)(1)
Category Lambda
=LAMBDA(x, from, to,
LET(
b, SWITCH(from,
"degK", x * 1 + 0,
"degC", x * 1 + 273.15,
"degF", x * 0.555555555555556 + 255.372222222222,
"degR", x * 0.555555555555556 + 0),
SWITCH(to,
"degK", (b - 0) / 1,
"degC", (b - 273.15) / 1,
"degF", (b - 255.372222222222) / 0.555555555555556,
"degR", (b - 0) / 0.555555555555556)
)
)(1, "degC", "degF")
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.
ConvertTemperature - In Refers to, paste the LAMBDA formula without the trailing invocation
(...) - Click OK
Now use =ConvertTemperature(1, "degC", "degF")
anywhere in your workbook — no add-in required.
Conversion Factors (base: degK)
| Unit | Name | Factor | Shift |
|---|---|---|---|
| degK | degree kelvin | 1 | |
| degC | degree Celsius | 1 | 273.15 |
| degF | degree Fahrenheit | 0.555555555555556 | 255.372222222222 |
| degR | degree Rankine | 0.555555555555556 |