Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multifunctional formula
How do I enter a multifunctional conversion formula in excel. I need to do
conversions of Kelvin to celcius and fahrenhiet and vice versa? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multifunctional formula
Just use the Convert function.
=convert(a1,"C","K") converts from Celsius to Kelvin. Use "F" for fahrenheit. Regards, Fred. "John T" <John wrote in message ... How do I enter a multifunctional conversion formula in excel. I need to do conversions of Kelvin to celcius and fahrenhiet and vice versa? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multifunctional formula
Take a look at the function CONVERT().
If the CONVERT function is not available, install and load the Analysis ToolPak add-in. From menu ToolsAdd-Inscheck 'ATP' hit OK.. If this post helps click Yes --------------- Jacob Skaria "John T" wrote: How do I enter a multifunctional conversion formula in excel. I need to do conversions of Kelvin to celcius and fahrenhiet and vice versa? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|