Hot Excel Tip -Convert Temperatures Using Excel

Pin It

This tip I find useful in converting the Irish/UK take on temperature in comparison to the USA temperatures,  I usually like to see the trends of temperatures of where I am going on my regular road trips to America.- It really handy!

 

It is a simple formula

 

Fahrenheit To Celsius (Temp refers to cell that  contains the temperature for conversion- cell B2)

=(Temp-32)*(5/9)

Celsius To Fahrenheit (Temp refers to cell that contains the temperature for conversion-cell B2)

=(Temp*1.8)+32

Want More Formula Fun?? 

Highlight All Cells That Contain A Formula

Hide Your Excel Formulas From Prying Eyes

Convert Excel Dates– Days To Months With The DAY() Function

Follow Me on Pinterest

Comments

  1. Another way of doing this would be using the convert function:

    =CONVERT(80,”F”,”C”) to convert 80F to C

    =CONVERT(80,”C”,”F”) to convert 80C to F

    Orlando Mezquita

Speak Your Mind

*