HomeApplicationOffice informationHow to convert Celsius to Fahrenheit in Excel

How to convert Celsius to Fahrenheit in Excel

 Then you can convert Celsius to Fahrenheit in Excel using a formula or function in Excel with a very simple implementation. The article below will guide you how to convert degrees Celsius to degrees Fahrenheit in Excel.

Convert Celsius to Fahrenheit in Excel using formula

First of all, you must remember that 0 °C = 32 °F, every 1 degree Celsius increase + 1.8 degrees Fahrenheit and every 1 degree Celsius decrease - 1.8 degrees Fahrenheit. The formula to convert Celsius to Fahrenheit in Excel is Number of degrees Fahrenheit = Number of degrees Celsius * 1.8 + 32.

Enter the calculation formula in the box then press Enter to get the result.

How to convert Celsius to Fahrenheit in Excel Picture 1

As a result, we get degrees Fahrenheit as shown below. You drag the first result cell down to the remaining cells to complete the Celsius to Fahrenheit conversion table in Excel.

How to convert Celsius to Fahrenheit in Excel Picture 2

 

How to convert Celsius to Fahrenheit in Excel using the Convert function

We have the Convert function formula = CONVERT (Number, From_Unit, To_Unit). In there:

  1. Number: is the converted value
  2. From_Unit: unit to convert
  3. To_Unit: conversion unit

You enter the function formula into the data table in Excel to change. The units used in the Convert function must be placed in double quotes as shown.

How to convert Celsius to Fahrenheit in Excel Picture 3

Then we press Enter and you will also see the result of degrees Fahrenheit being converted from degrees Celsius.

How to convert Celsius to Fahrenheit in Excel Picture 4

Finally, we just need to drag the first result cell down to the remaining cells to display it as shown below.

How to convert Celsius to Fahrenheit in Excel Picture 5

5 ★ | 2 Vote

You should read it

May be interested

  • 4 ways to insert the Celsius symbol in Excel on all versionsPhoto of 4 ways to insert the Celsius symbol in Excel on all versions
    to insert the celsius degree symbol in excel, we have many different ways to do it like when inserting the degree symbol in word.
  • 16 best free PDF reading softwarePhoto of 16 best free PDF reading software
    are you looking for free pdf reading software for your windows 10, 7 or windows 8 computer? please refer to the list of the best pdf file reading software that we introduce below.
  • How to Create Invitations in Microsoft WordPhoto of How to Create Invitations in Microsoft Word
    you may want to send formal invitations to family and friends if you're planning a get-together, a small celebration at home, or a birthday party. this type of invitation can be created right on word. microsoft word offers the option to create custom invitations with a variety of layout tools and templates, then simply print them out. not only does it help save costs, but the invitation card also brings your personal touch.
  • Fix copying errors with line breaks in Word super fastPhoto of Fix copying errors with line breaks in Word super fast
    copy with line breaks affecting your usage experience? let tipsmake help you fix copy errors with broken lines in word!
  • PowerPoint cannot insert MP4 videosPhoto of PowerPoint cannot insert MP4 videos
    if you want to make a presentation, many people will think of powerpoint. but powerpoint cannot insert mp4 videos, making the operation difficult
  • Mathtype display error - Simple fixPhoto of Mathtype display error - Simple fix
    mathtype display error is a very common error among word users. to know how to fix it, read tipsmake's article immediately

Office information