# Converting Temperatures: Celsius To Fahrenheit In Google Sheets

Converting temperatures from Celsius to Fahrenheit or vice versa can be a tedious task if done manually.

However, with the power of Google Sheets, this task can be easily accomplished with a simple formula.

In this article, we will show you how to convert temperatures from Celsius to Fahrenheit and vice versa in Google Sheets.

## Formula For Converting Celsius To Fahrenheit

The formula for converting Celsius to Fahrenheit is: = (9/5) * C + 32 Where C is the temperature in Celsius.

## Formula For Converting Fahrenheit To Celsius

The formula for converting Fahrenheit to Celsius is: = (F - 32) * 5/9 Where F is the temperature in Fahrenheit.

## Using The Formulas In Google Sheets

To use the formulas in Google Sheets, simply enter the desired formula in a cell and replace the C or F with the cell that contains the temperature.

For example, if you have a temperature of 25 degrees Celsius in cell A1, you would enter the following formula in a new cell: = (9/5) * A1 + 32 This would then give you the temperature in Fahrenheit, 77 degrees.

## Visualizing The Conversion

To visualize the conversion, you can create a chart in Google Sheets.

To do this, select the cells with the converted temperatures and insert a line chart.

This will give you a clear visual representation of the conversion from Celsius to Fahrenheit or vice versa.

## Conclusion

Converting temperatures from Celsius to Fahrenheit or vice versa can be easily accomplished with the use of formulas in Google Sheets.