Thermodynamic Temperature Unit Converter in Excel
1 degree Celsius = 33.8 degree Fahrenheit
Formula for this pair
This scale also has a starting point. 0 °C is 32 °F, so a simple multiple would be wrong. The formula adds that difference.
=LAMBDA(value,LET(fromFactor,1,fromShift,273.15,toFactor,0.5555555555555556,toShift,255.3722222222222,(value*fromFactor+fromShift-toShift)/toFactor))(1)
Once you have saved the function below, type this in a cell
=ConvertThermodynamicTemperature(1, "degC", "degF")
CONVERT
Paste this into a cell. Excel's CONVERT function knows both of these units.
=CONVERT(1, "C", "F")
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 ConvertThermodynamicTemperature. Leave the scope as Workbook.
- Paste the function into Refers to.
- In a cell, type the call shown above.
ConvertThermodynamicTemperature
Show the full function
=LAMBDA(value,from_unit,to_unit,LET(fromFactor,SWITCH(from_unit,"K",1,"degK",1,"degC",1,"degF",0.5555555555555556,"degR",0.5555555555555556),fromShift,SWITCH(from_unit,"K",0,"degK",0,"degC",273.15,"degF",255.3722222222222,"degR",0),toFactor,SWITCH(to_unit,"K",1,"degK",1,"degC",1,"degF",0.5555555555555556,"degR",0.5555555555555556),toShift,SWITCH(to_unit,"K",0,"degK",0,"degC",273.15,"degF",255.3722222222222,"degR",0),(value*fromFactor+fromShift-toShift)/toFactor))
Conversion factors
The factors this converter uses. Copy them into Excel as tab-separated values.
| Symbol | Name | Factor | Offset | Excel code |
|---|---|---|---|---|
| K | degree kelvin | 1 | 0 | K |
| degK | degree kelvin | 1 | 0 | K |
| degC | degree Celsius | 1 | 273.15 | C |
| degF | degree Fahrenheit | 0.5555555555555556 | 255.3722222222222 | F |
| degR | degree Rankine | 0.5555555555555556 | 0 | Rank |
Notes
Celsius and Fahrenheit do not start at the same point. 0 °C is 32 °F, so multiplying is not enough. The formula adds that difference. Kelvin and Rankine use the same formula, and both differences are zero.
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.