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:


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.


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



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


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 ...

Google Sheets WORKDAY Function

This post will guide you how to use Google Sheets WORKDAY function with syntax and examples. Description The Google Sheets WORKDAY function returns a date or a serial number that represents a date that is the indicated number of working ...

How to Use COUNTIFS function with Multiple Criteria and OR Logic in Excel

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 ...


So empty here ... leave a comment!

Leave a Reply