Microsoft Excel Functions & Formulas

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.

4

To convert from Celsius to Fahrenheit:

1. In a worksheet, enter a few temperatures in Celsius in col-

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