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