Fresh Excel Tips

In this tutorial we will teach you how to convert from Fahrenheit to Celsius in Excel as well as how to convert from Celsius to Fahrenheit. For our first example, we will use the first formula, =(Fahrenheit–32)*5/9. Here is how we will make the conversion.

How to convert from Fahrenheit to Celsius:

1. Open Microsoft Excel. This formula is compatible in Excel 97, 2003 and 2007.
2. In a worksheet, enter your temperatures in Fahrenheit in column A.
3. Select cells B2:B14 and type the following formula: =(A2*1.8)+32.
4. Press Ctrl+Enter.

To convert temperatures from Celsius to Fahrenheit, you will have to use the formula = (Celsius *9/5)+32. Here is how to apply it.

How to convert from Celsius to Fahrenheit:

1. In a worksheet, enter your temperatures in Celsius in column A.
2. Select cells B2:B14 and type the following formula: =(A2-32)/1.8.
3. Press CTRL+Enter.

You should now be set.

1. How to Convert Currencies in Excel
2. Convert feet per minute to meters per second in Excel
3. Convert Miles per hour to Km per hour in Excel.
4. How to Convert from hours to minutes in Excel
5. Convert Liters to Barrels, Gallons, Quarts and Pints in Excel