Convert Celsius to Fahrenheit in Excel & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on February 6, 2023
Download Example Workbook

Download the example workbook

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

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to Excel Formulas List