This tutorial will demonstrate how to convert temperatures from Celsius to Fahrenheit in Excel & Google Sheets.

convert celsius to fahrenheit

Conversion of Celsius to Fahrenheit

The CONVERT function can be used to convert temperature from Celsius to Fahrenheit.

Let’s say in column B we have temperatures recorded as Celsius and in column C we want the equivalent value in Fahrenheit. Type the following formula in cell C5 and drag it down:

=CONVERT(B5, "C", "F")

convert c to f

The CONVERT function converts a number from one measurement unit to another.

And for conversion, the CONVERT function depends on the unit from which conversion is taking place and to the required unit of the measurement.

Conversion of Fahrenheit to Celsius

If you want to convert temperature from Fahrenheit to Celsius, just use the following formula:

=CONVERT(B3, "F", "C")

convert f to c

Conversion from Celsius to Fahrenheit in Google Sheets

The conversion of Celsius to Fahrenheit formula works exactly the same in Google Sheets as in Excel:

convert c to f google sheets