Temperature Conversion in Excel
Excel 2007 and Excel 2010 make it easy to convert between different units, such as temperatures using the
It is used as follows:
=CONVERT(number, from_unit, to_unit). Where:
numberis the temperature you want to convert
from_unitis the symbol of the unit you want to convert from, e.g. “C” for Celsius, “F” for Fahrenheit, or “K” for Kelvin. If you start typing the formula, Excel will pop up a list of options for you to choose from. Remember to use quotes, e.g. “C”.
to_unitis the symbol of the unit you want to convert to.
- Convert 40°C to °F:
=CONVERT(40, "C", "F")
- Convert -40°F to °C:
=CONVERT(-40, "F", "C")
- Convert 0°K to °C:
=CONVERT(0, "K", "C")
You can also store the value to convert in a cell, and use the formula to output the converted cell. For example, if you type the input °C value in cell A1, you could use the following to convert it to Fahrenheit:
=CONVERT(A1, "C", "F")