Microsoft Office Tutorials and References
In Depth Information
Converting Temperatures
Converting Temperatures
This tip presents formulas for conversion among three units of temperature: Fahrenheit, Celsius,
and Kelvin.
The formulas in Table 127-1 assume that the temperature for conversion is in a cell named temp.
Table 127-1: Temperature Conversion Formulas
Type of Conversion
Formula
Fahrenheit to Celsius
=(temp-32)*(5/9)
Fahrenheit to Kelvin
=(temp-32)*(5/9)+273
Celsius to Fahrenheit
=(temp*1.8)+32
Celsius to Kelvin
=temp+273
Kelvin to Celsius
=temp-273
Kelvin to Fahrenheit
=((temp-273)*1.8)+32
 
Search JabSto ::




Custom Search