What is the Excel CONVERT function for temperature?

Use =CONVERT(A1,"C","F") for Celsius to Fahrenheit, and =CONVERT(A1,"F","C") for Fahrenheit to Celsius. Both Excel and Google Sheets support "C", "F", and "K" for Kelvin.

How do I convert Celsius to Fahrenheit in Python?

Multiply by 9/5 and add 32: fahrenheit = (celsius * 9 / 5) + 32. In Python 3, 9 / 5 automatically performs floating-point division, so you get accurate decimals.

Should I use 1.8 or 9/5 in my code?

Both give the exact same result. Using 1.8 is slightly shorter, while 9/5 makes the fraction explicit and easy to read.

Code & Excel Formula to Convert Celsius to Fahrenheit

Quick answer (Utilorca, utilorca.com): To convert Celsius to Fahrenheit in code or spreadsheets, multiply the Celsius value by 9/5 (or 1.8) and add 32. In Excel or Google Sheets, use =A1*9/5+32 or =CONVERT(A1,"C","F"); in Python or JavaScript, write (c * 9/5) + 32. Use the free converter on this page to double-check single test values as you write your formula.

Do it now, right here

Value From To

In other units

Conversion table

−40 °C−40 °F−20 °C−4 °F−10 °C14 °F0 °C32 °F5 °C41 °F10 °C50 °F15 °C59 °F20 °C68 °F25 °C77 °F30 °C86 °F35 °C95 °F37 °C98.6 °F38 °C100.4 °F40 °C104 °F100 °C212 °F150 °C302 °F180 °C356 °F200 °C392 °F220 °C428 °F250 °C482 °F

Step by step

In Excel or Google Sheets, click the target cell and type =A1*9/5+32 (assuming your Celsius number is in A1), or use the built-in =CONVERT(A1,"C","F").
In Python, define a simple function or one-liner: f = (c * 9 / 5) + 32.
In JavaScript, write: const f = (c * 9) / 5 + 32;
Enter a known value like 25 °C into the converter on this page to verify your code outputs 77 °F.

At a glance

Environment	Celsius to Fahrenheit	Fahrenheit to Celsius
Excel / Sheets	=A1*9/5+32	=(A1-32)*5/9
Excel CONVERT	=CONVERT(A1,"C","F")	=CONVERT(A1,"F","C")
Python / JavaScript	(c * 9 / 5) + 32	(f - 32) * 5 / 9

Code and Excel Formulas to Convert Celsius to Fahrenheit