Exceljet

Quick, clean, and to the point

Celsius to Fahrenheit conversion

Excel formula: Celsius to Fahrenheit conversion
Generic formula 
=CONVERT(A1,"C","F")
Explanation 

To build a simple table to convert temperature from Celsius to Fahrenheit, you can use the CONVERT function. In the example shown, the formula in C5, copied down, is:

=CONVERT(B5,"C","F")

The results in column C will update automatically when values in column B change.

How this formula works

This formula relies on the CONVERT function, which can convert a number in one measurement system to another.  CONVERT is fully automatic and based on "from" and "to" unit strings. As long as the units valid options in the same category (weight, distance, temperature, etc.) , CONVERT will automatically perform a conversion and return a numeric result.

To convert from Celsius to Fahrenheit, use a "C" for Celsius and an "F" for Fahrenheit like this:

=CONVERT(B5,"C","F")

Note: unit strings are case sensitive. Both the "C" and "F" must be uppercase.

Fahrenheit to Celsius

To convert from Fahrenheit to Celsius, the formula would be:

=CONVERT(B5,"F","C")

Other conversions

You can use CONVERT to convert weight, distance, time, pressure, force, energy, power, magnetism, temperature, liquid, and volume. Unit strings must be valid and in the proper case. This page shows available options in each category.

Author 
Dave Bruns

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.