Multifunctional formula

[John T]

How do I enter a multifunctional conversion formula in excel. I need to do
conversions of Kelvin to celcius and fahrenhiet and vice versa?

 

[Fred Smith]

Just use the Convert function.

=convert(a1,"C","K")

converts from Celsius to Kelvin. Use "F" for fahrenheit.

Regards,
Fred.

 

[Jacob Skaria]

Take a look at the function CONVERT().

If the CONVERT function is not available, install and load the Analysis
ToolPak add-in. From menu >Tools>Add-Ins>check 'ATP' hit OK..

If this post helps click Yes