ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Multifunctional formula (https://www.excelbanter.com/excel-worksheet-functions/245209-multifunctional-formula.html)

John T[_2_]

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?

Fred Smith[_4_]

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?



Jacob Skaria

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