How to Convert Fahrenheit to Celsius or Kelvin in Microsoft Excel

This post will guide you how to Convert Temperatures among Fahrenheit, Celsius, and kelvin using a formula in Microsoft Excel. How do I convert Fahrenheit to Celsius in Excel 2013/2016. How to convert degrees Fahrenheit to degrees Celsius in Excel. The Fahrenheit unit is a measure of temperature primarily used in the United States, but most of countries in Europe are using Celsius Units for temperature. Sometimes you may be need to measure Fahrenheit and convert it to Celsius. This post will show you one method to convert it.

Convert Fahrenheit to Celsius


Assuming that you have a list of data in range B1:B5 in which contain some temperature values and its unit is Fahrenheit. And you want to convert Fahrenheit to Celsius for those values in the current worksheet. You can easily use a built-in function called CONVERT to accomplish it. And this function can be used to convert between different units of measurement. The CONVERT function needs three arguments that you need to provide, the first argument is the value that you would like to convert, the second argument is the unit of measurement you are converting from, and the last argument is the unit of measurement of you are converting to. So you can use the following formula to convert your data from Fahrenheit unit to Celsius:

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

Type this formula into a blank cell, such as: C1, and press Enter key on your keyboard to complete the conversion. And then drag the AutoFill handle over to cell C5 to apply this formula.

convert-fahrenheit-to-celsius1

Note: if you want to convert Celsius to Fahrenheit, just use the following formula based on the CONVERT function:

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

convert-fahrenheit-to-celsius2

And if you want to Convert Fahrenheit to Kelvin, just using the following formula:

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

convert fahrenheit to celsius3
Related Posts

BMI Calculation Formula In Ms Excel

You might have come across a task in which you were assigned to make BMI calculations of the supplied numbers, and you may be looking for an efficient approach to accomplish this process rather than doing BMI calculations manually, by ...

How to Use COUNTIFS function with Multiple Criteria and OR Logic in Excel
countifs function with multiple criteria or logic4

This post will guide you how to Use COUNTIFS function with multiple criteria and OR logic in Excel 2013/2016 or Excel office 365. How to count with multiple criteria and OR logic in Excel. COUNTIFS with Multiple Criteria and OR ...

How to Count Numbers that begin with Specific Value  in Excel

This post will guide you how to count numbers that begin with a specific value or number in Excel 2013/2016 or Excel office 365. How do I count the number of values that begin with a given specific value by ...

How to Sum Data if by Year in Excel

In statistic, to create a yearly report for showing the market trend on different years, we often sum a total for different years, so based on the year’s total we can do estimation for the coming year. This scenario frequently ...

How to Auto Convert KB, MB, GB, PG, TB in Excel
convert kb mb unit5

This post will guide you how to convert value in KB format to MB, GB, PB and TB automatically in Microsoft Excel. How do I convert size in bytes to KB, MB, GB, TB and PB in Excel 2013/2016. For ...

How to Convert Ounces to Pounds or Grams in Excel
convert ounces to pounds3

This post will guide you how to convert ounces to pounds or grams with formula in Excel. How do I convert pounds to ounces or grams in Excel 2013/2016. Convert Ounces to Pounds Assuming that you have a list of ...

How to Convert the Unit of Measurement for Cells in Excel
convert unit measurement1

This post will guide you how to convert the unit of measurement from one unit to another in Excel. How do I convert various unit measurements in cells with a formula in Excel 2013/2016. Convert Unit of Measurement Assuming that ...

How to Change the Orientation of Worksheet in Excel
change orientation of worksheet1

This post will guide you how to change the default Portrait orientation to Landscape page orientation in your worksheet in Excel. Change the Orientation of Worksheet When you have a list of data with lots of columns, you can try ...

How to Convert Times in Excel
convert times4

This post will guide you how to convert hours into minutes with a formula in Excel. How do I convert time to hours, minutes, or seconds or days in Excel. Convert between Time Units If you want to find out ...

Convert measurements
convert feet to inches4

This post will guide you how to convert feet to inches in Excel. How to convert feet to meters in Excel. How to convert fee to inches or meters with CONVERT function in Excel. Convert Feet to Inches with a ...

Sidebar