![]() |
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? |
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? |
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? |
All times are GMT +1. The time now is 09:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com