From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Format cells to show degrees in Celsius and Fahrenheit

Format cells to show degrees in Celsius and Fahrenheit - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Format cells to show degrees in Celsius and Fahrenheit

“

- [Instructor] Hello, hello, okay, we are going to be dealing with Celsius and Fahrenheit temperatures. And formatting cells. The first objective, put the data into a table. And then format the temperature C column so that whenever you type a number in there, it will show with that circle symbol and a capital C. Also, we want to do the same for Fahrenheit in that Temp F column. But in that Temp F column, we want a conversion calculation so that we know that 10 degrees Celsius is whatever it is in Fahrenheit. Also, write the formula so that if there is nothing in the Temp C column, that the Temp F will not calculate because look at day eight. With that being blank, if you don't write a formula trigger, the formula will read that blank as a zero and then give us 32 degrees Fahrenheit, which is not right. Okay? Take a deep breath. It is a lot. Pause the video. Get all this worked out. Then come on back.…

Contents