When it comes to temperatures, I’ve been brought up with Fahrenheit. So when the weather report on TV says it’s going to be in the 80’s, I know it’ll be hot, but when I look at the weather app on my iPhone and it says 13 Celsius, I have no idea what that means (Luckily the weather app lets me I can switch between F and C). This tutorial shows how to convert Fahrenheit to Celsius and vice versa.

In the screenshot below, B1 contains a Celsius value and B10 contains a Fahrenheit value.

convert function

The formula in B6, which converts it to Fahrenheit, is =CONVERT(B1,”C”,”F”)

The formula in B15, which converts it to Celsius, is =CONVERT(B10,”F”,”C”)