Convert Celsius to Fahrenheit or Vice Versa

In this article, I will show you how to convert Celsius to Fahrenheit or vice versa.

This solution works the same in Excel and Google Sheets.

The Setup

Start by storing your initial measure in Celsius or Fahrenheit in your spreadsheet. Next, identify where you want the converted measurement to go.

You are now ready for the conversion.

The Formula

Select the cell where you want your converted measurement. Then, enter one of the following formulas.

To convert Celsius to Fahrenheit.

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

To convert Fahrenheit to Celsius.

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

And that is the easiest way to convert your temperature measurement in Excel or Google Sheets.