3 Ways to Convert Between Celsius and Fahrenheit in Google Sheets

This post is going to show all the ways you can use to convert temperature values between Celsius and Fahrenheit measurement in Google Sheets.

When you are working with data that consists of temperature values, it is sometimes needed to convert the data from Celsius to Fahrenheit or vice versa.

The Celsius or Fahrenheit scale of temperature allows you to understand the temperature of a body or an object.

Though Celsius is a standard measure for most countries, there are still few that follow the Fahrenheit scale of measuring the temperature.

The methods discussed throughout this article will undoubtedly help you to get this done quickly.

You will learn all the different methods of converting the temperature across these scales through a simple formula as well as through a built-in formula. Get your copy of the example workbook with the link above and follow along.

Convert Temperature with a Basic Formula

Conversion between Celsius and Fahrenheit can be a common task when dealing with scientific or medical data from other countries since they are both widely used temperature scales.

Converting between the two scales is easy when you know how!

Convert Celsius to Fahrenheit with a Basic Formula

A standard way to convert a temperature from Celsius to Fahrenheit is using a basic algebraic formula.

F = (C * 9/5) + 32
  • F represents the output temperature you need in the Fahrenheit scale.
  • C represents the input temperature measured in the Celsius scale.
  • 9/5 and 32 are universal constants used for the temperature conversion from Celsius to Fahrenheit.

Suppose you have the data above where column A represents all the temperature values measured in Celsius. In column B, you want to convert those into temperature values in Fahrenheit.

=(A2*9/5)+32

To achieve the results, in cell B2, type the above formula which is the Google Sheet equivalent to the standard algebraic Celsius to Fahrenheit formula.

Drag the formula down the rows to get the desired Fahrenheit temperature results across cells B2:B6.

Your Celsius values are now available in Fahrenheit!

Convert Fahrenheit to Celsius with a Basic Formula

For a reverse situation where you want to convert the Fahrenheit temperature values into Celsius, you can solve the previous formula for C and obtain the following formula.

C = (F - 32) * 5/9

Where the C and F represent the same Celsius and Fahrenheit temperatures respectively.

=(D2-32)*5/9

To convert the Fahrenheit values in column D, use the above formula in cell E2.

You now have the Celsius equivalent values!

Convert Temperature with the CONVERT Function

The Google Sheets CONVERT function is the best way to convert a numeric value into some other unit of measurement.

It is able to convert many types of measurements including temperatures.

Syntax of the CONVERT Function

=CONVERT(value, start_unit, end_unit)
  • value a numeric value you want to convert from one measure to another.
  • start_unit a unit in which the values are stored in.
  • end_unit a unit you want the values to convert into.

An interesting fact about the function is, it allows you to convert from hundreds of measuring units across the thirteen different categories such as weight, pressure, temperature, etc.

Convert Celsius to Fahrenheit with the CONVERT Function

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

To convert the data from Celsius to Fahrenheit, input the above formula in cell B2 and drag it down the rows.

The start_unit "C" represents the Celsius scale of temperature measurement and assumes that the value stored in cell A2 is in Celsius.

The end_unit parameter has the value "F" which informs the system that the conversion should be into Fahrenheit.

The results are all the values in Fahrenheit.

Convert Fahrenheit to Celsius with the CONVERT Function

You can use the CONVERT function to have Fahrenheit values converted to the Celsius temperature values.

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

Use the above formula across the cells of column E and this will convert the Fahrenheit values in column D into Celsius.

The formula is similar to the previous one. All you need to do is switch the position of start_unit and end_unit.

These are the two ways using which you can convert a Celsius temperature value into Fahrenheit and vice-versa.

Shortcut way to Convert Temperature to Approximate Values

The way I am about to tell is not going to give you an adequate temperature conversion from Celsius to Fahrenheit when precision is not required.

However, it is quick to use and gives good approximate values that are close enough for some uses.

Shortcut Conversion from Celsius to Fahrenheit

Though most of the time you need exact values, sometimes the approximate values will do the job as well for you.

In such cases, if you do not remember the standard conversion formula or the CONVERT function, this tip might come in handy.

To convert the Celsius temperature to its approximate Fahrenheit equivalent, multiply your Celsius temperature by 2 and add 30.

(20 * 2) + 30 = 70°F

For Example, if you want to convert the 20°C to the approximate Fahrenheit, the above will be a good approximation.

Shortcut Conversion From Fahrenheit to Celsius

On the other hand, if you subtract 30 from the given Fahrenheit temperature and divide it by 2, you will get the approximate temperature in Celsius.

(70 - 30)/2 = 20oC

For example, converting 70°F to Celsius will return the temperature value as 20°C.

This method is not perfect, but if the approximate temperature conversion is good enough then it will give you a quick and easy way you can calculate the conversion in your head.

Conclusion

The conversion of temperature values between the Celsius to Fahrenheit values is a common problem as different countries follow different measurement scales for the temperatures.

You have seen two ways to convert temperature from one measure to another.

The first method is to use the standard algebraic conversion formulas when converting between Celsius values and Fahrenheit.

The second method uses the CONVERT function which allows you to convert hundreds of measurement scales from various categories. This can also be used to convert temperatures between Celsius and Fahrenheit!

You can also use the approximate conversion formula to convert temperature from Celsius to Fahrenheit and vice-versa when precision is not needed.

Have you ever needed to convert between Celsius and Fahrenheit in your Google Sheets? Did you use any of these methods? Let me know in the comments below!

About the Author

Lalit Salunkhe

Lalit Salunkhe

Lalit is a data analyst with diverse skills and experience in data mining and analysis. He has a M.Sc. in Statistics from one of the top institutes in Maharashtra. Lalit is also a Google Sheets expert and enjoys teaching others how to use Google Sheets to solve their data problems.

Related Articles

Comments

0 Comments

Submit a Comment

Your email address will not be published.

Get the Latest Google Sheets Tips

Write For Us

Are you a tech enthusiast with a talent for writing great content? Come write for us!

Follow Us

Follow us on social media to stay up to date with the latest in Google Sheets!