G
Guest
I am trying to create a custom function in Excel XP to automatically convert
temperatures from Farenheit to Celsius and vice versa.
temperatures from Farenheit to Celsius and vice versa.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Ajtb
Hi
F = 1.8C + 32
C = (F-32)/1.8
This function,
Function F1(C)
F1 = 1.8C + 32
End Function
- will convert Celsius to Fahrenheit.
Regards
Andrew Bourke
F = 1.8C + 32
C = (F-32)/1.8
This function,
Function F1(C)
F1 = 1.8C + 32
End Function
- will convert Celsius to Fahrenheit.
Regards
Andrew Bourke
N
Niek Otten
=CONVERT(A1,"C","F")
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
B
Bob Phillips
Take a look at the CONVERT function in help, there are many other
conversions as well as C to F.
--
HTH
RP
(remove nothere from the email address if mailing direct)
conversions as well as C to F.
--
HTH
RP
(remove nothere from the email address if mailing direct)
T
Tom Ogilvy
Just to add (from help):
If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using Add-Ins on the Tools menu.
If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using Add-Ins on the Tools menu.