To convert the Fahrenheit values in column D, use the above formula in cell E2. Where the C and F represent the same Celsius and Fahrenheit temperatures respectively. Your Celsius values are now available in Fahrenheit! Convert Fahrenheit to Celsius with a Basic Formulaįor 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. 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.ĭrag the formula down the rows to get the desired Fahrenheit temperature results across cells B2:B6. In column B, you want to convert those into temperature values in Fahrenheit. Suppose you have the data above where column A represents all the temperature values measured in Celsius. 9/5 and 32 are universal constants used for the temperature conversion from Celsius to Fahrenheit.C represents the input temperature measured in the Celsius scale.F represents the output temperature you need in the Fahrenheit scale.Convert Temperature with a Basic FormulaĬonversion 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.Ĭonverting between the two scales is easy when you know how! Convert Celsius to Fahrenheit with a Basic FormulaĪ standard way to convert a temperature from Celsius to Fahrenheit is using a basic algebraic formula.

Get your copy of the example workbook with the link above and follow along. 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. The methods discussed throughout this article will undoubtedly help you to get this done quickly.

Though Celsius is a standard measure for most countries, there are still few that follow the Fahrenheit scale of measuring the temperature. The Celsius or Fahrenheit scale of temperature allows you to understand the temperature of a body or an object.

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. This post is going to show all the ways you can use to convert temperature values between Celsius and Fahrenheit measurement in Google Sheets.

Formula to convert f to c