Hot Excel Tip -Convert Temperatures Using Excel

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

Comments

  1. says

    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

Leave a Reply

Your email address will not be published. Required fields are marked *