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
Frepresents the output temperature you need in the Fahrenheit scale.
Crepresents the input temperature measured in the Celsius scale.
32are 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.
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
F represent the same Celsius and Fahrenheit temperatures respectively.
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)
valuea numeric value you want to convert from one measure to another.
start_unita unit in which the values are stored in.
end_unita 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.
"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.
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!