Excel: Convert Temperatures Between Celsius, Fahrenheit, and Kelvin

It’s not difficult to enter a formula into Microsoft Excel to convert between Celsius, Fahrenheit, and Kelvin, but why not use a built-in function to do the work for you? Meet CONVERT, a handy function that lets you convert between different units of measurement. It’s not limited to temperatures, but those are the only units I’m going to discuss in this post.

The CONVERT function needs three pieces of information from you: the value that you would like to convert, the unit of measurement you are converting from, and the unit of measurement you are converting to.

If the temperature is in cell A1 and is measured in Celsius, then use this formula to convert it to Fahrenheit:

=CONVERT(A1,"C","F")

If the temperature is measured in Fahrenheit, then use this formula to convert it to Celsius:

=CONVERT(A1,"F","C")

Use the same function but replace the “F” (Fahrenheit) or “C” (Celsius) with a “K” if you are looking to convert to Kelvin. For example, this formula will convert a temperature from Fahrenheit to Kelvin:

=CONVERT(A1,"F","K")

Make sense? Feel free to post a comment if you’re having trouble.
Read More