Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert Celsius to Fahrenheit in Excel and Google Sheets
Topic:Unit conversionExcel & Google Sheets
=CONVERT(B2,"C","F")Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter Celsius temperatures in column B.
- 2In column C, enter =CONVERT(B2,"C","F") to convert to Fahrenheit.
- 3Alternatively, use =(B2*9/5)+32 for a transparent formula.
- 4Copy the formula down for all temperature readings.
Tips
- Use =(B2*9/5)+32 when you want the formula to be self-explanatory in documentation or when CONVERT availability is uncertain.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Can I convert Fahrenheit back to Celsius?
Yes. Use =CONVERT(B2,"F","C") or the manual formula =(B2-32)*5/9.
Does CONVERT support Kelvin?
Yes. Use "K" as the unit identifier. For example =CONVERT(B2,"C","K") converts Celsius to Kelvin.
More on Unit conversion
See all →How-to
How to convert minutes to hours
Turn a number of minutes into decimal hours by dividing by 60. The same simple formula in Excel and Google Sheets.
How-toHow to convert inches to centimeters
Multiply the inch value by 2.54 or use the CONVERT function to change inches to centimeters in Excel or Google Sheets.
How-toHow to convert kilograms to pounds
Multiply kilograms by 2.20462 or use CONVERT to change kg to pounds in Excel or Google Sheets instantly.
How-toHow to convert miles to kilometers
Multiply miles by 1.60934 or use CONVERT with 'mi' and 'km' units to change miles to kilometers in Excel or Sheets.
How-toHow to convert feet to meters
Multiply feet by 0.3048 or use CONVERT with 'ft' and 'm' to change feet to meters in Excel or Google Sheets.
How-toHow to convert bytes to megabytes
Divide byte values by 1048576 (2^20) to convert bytes to megabytes in Excel or Google Sheets.