Convert from Celsius to Fahrenheit - Formulas In Excel - Microsoft Excel Tutorials

25.  Convert from Celsius to Fahrenheit

To convert temperatures from Celsius to Fahrenheit, you can use the formula = (Celsius *9/5)+32, or you can use the calculation described here.

To convert from Celsius to Fahrenheit:

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

Note: You can create a user-defined format to insert the degree sign (°). Go to the Format menu, and select Cells, Number, Custom. In the Type box, select General and press OK. Select a cell, hold down the <-Alt-> key, type 0176 on the numeric keypad, then release <-Alt-> and type either “F” or “C” without the quotes.

Watch the Video Tutorial - https://www.youtube.com/watch?v=jn22e9NdZiw

 

Hope You Enjoy This Tutorial - Give Comments