Need to convert temperature from Farenheit to Celsius
 

I am trying to create a custom function in Excel XP to automatically convert
temperatures from Farenheit to Celsius and vice versa.

Need to convert temperature from Farenheit to Celsius
 

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

Sam wrote:
I am trying to create a custom function in Excel XP to automatically convert
temperatures from Farenheit to Celsius and vice versa.

Need to convert temperature from Farenheit to Celsius
 

=CONVERT(A1,"C","F")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Sam" wrote in message
...
I am trying to create a custom function in Excel XP to automatically
convert
temperatures from Farenheit to Celsius and vice versa.

Need to convert temperature from Farenheit to Celsius
 

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)


"Sam" wrote in message
...
I am trying to create a custom function in Excel XP to automatically
convert
temperatures from Farenheit to Celsius and vice versa.

Need to convert temperature from Farenheit to Celsius
 

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.
-------

so convert is provided by the Addin Analysis Toolpak (shipped with Excel,
but not necessarily installed or selected in tools=Addins)


--
Regards,
Tom Ogilvy

"Niek Otten" wrote in message
...
=CONVERT(A1,"C","F")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Sam" wrote in message
...
I am trying to create a custom function in Excel XP to automatically
convert
temperatures from Farenheit to Celsius and vice versa.