Temperature Conversion in Excel

less than 1 minute read

Excel 2007 and Excel 2010 make it easy to convert between different units, such as temperatures using the CONVERT() function.

It is used as follows: =CONVERT(number, from_unit, to_unit). Where:

  • number is the temperature you want to convert
  • from_unit is 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_unit is the symbol of the unit you want to convert to.

Examples

  • 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")

Tags:

Categories:

Updated: