How to Convert from Fahrenheit to Celsius in Excel

In this article, we will learn how to convert temperatures from Fahrenheit to Celsius using Excel formulas. This is a useful skill for anyone who needs to work with different units of temperature, such as scientists, engineers, travelers, or students.

Fahrenheit and Celsius are two scales for measuring temperature. They are related by the following formula:

C=5/9​×(F−32)

where C is the temperature in Celsius and F is the temperature in Fahrenheit.

To convert from Fahrenheit to Celsius, we need to subtract 32 from the Fahrenheit value, multiply by 5, and divide by 9.

Procedures

To convert from Fahrenheit to Celsius in Excel, we can use the following steps:

• Enter the Fahrenheit values in a column, such as column A.
• In the adjacent column, such as column B, enter the formula =(A1-32)*5/9 and press Enter. This will convert the value in A1 from Fahrenheit to Celsius and display the result in B1.
• Copy the formula down to the rest of the column to convert all the Fahrenheit values to Celsius.

Example

Let’s say we have a table of temperatures in Fahrenheit in column A, as shown below:

To convert them to Celsius, we can use the formula =(A2-32)*5/9 in cell B2 and copy it down to the rest of the column B. The result will look like this:

Other Approaches

There are other ways to convert from Fahrenheit to Celsius in Excel, such as using the CONVERT function or creating a custom function. Here are some examples:

• Using the CONVERT function: The CONVERT function can convert between various units of measurement, including temperature. The syntax of the function is =CONVERT(number, from_unit, to_unit), where number is the value to convert, from_unit is the original unit, and to_unit is the desired unit. To convert from Fahrenheit to Celsius, we can use the formula =CONVERT(A2, "F", "C") in cell B2 and copy it down to the rest of the column B.
• Creating a custom function: We can also create a custom function in Excel using Visual Basic for Applications (VBA). This allows us to define our own formula that can convert from Fahrenheit to Celsius. To create a custom function, we need to follow these steps:
  • Open the Visual Basic Editor by pressing Alt + F11 on the keyboard.
  • Insert a new module by clicking Insert > Module on the menu bar.
  • In the module window, type the following code:

    Function FtoC(F As Double) As Double
      'This function converts Fahrenheit to Celsius
      FtoC = (F - 32) * 5 / 9
    End Function
    

  • Save and close the Visual Basic Editor.
  • In Excel, we can use the formula =FtoC(A2) in cell B2 and copy it down to the rest of the column B.