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
Orlando Mezquita 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
Barbara says
Orlando
Excellent tip! Love that
Regards
Barbara