CONVERT FROM CELSIUS TO FAHRENHEIT USING MICROSOFT EXCEL


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*1.8)+32)
3. Press <-Ctrl+Enter->.

CONVERT FROM CELSIUS TO FAHRENHEIT USING MICROSOFT EXCEL
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.

Microsoft Excel Tutorials, Convert from celsius to fahrenheit using microsoft excel, Microsoft Excel Video Tutorials, Microsoft Excel Advanced Tutorials, Basic Tutorials, Formulas in Excel

No comments:

Post a Comment