Need to convert temperature from Farenheit to Celsius

[Sam]

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

[djvice]

Insert in a standard module....

Function CtoF(Centigrade)
CtoF = Centigrade * 9 / 5 + 32
End Function

Function FtoC(Fahrenheit)
FtoC = (Fahrenheit - 32) * 5 / 9
End Function


From the Excel formulas list, select User Defined.
CtoF = Celsius to Fahrenheit
FtoC = Fahrenheit to Celsius

Enter the range of where the variable is located...or enter a figure.

Good luck

[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

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

[Niek Otten]

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Sam" <Sam@discussions.microsoft.com> wrote in message
news:75018EAE-E6AF-4ADA-8719-F52E1830E164@microsoft.com...
>I am trying to create a custom function in Excel XP to automatically
>convert
> temperatures from Farenheit to Celsius and vice versa.

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

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" <nicolaus@xs4all.nl> wrote in message
news:uT$Nv%236JFHA.1040@TK2MSFTNGP10.phx.gbl...
> =CONVERT(A1,"C","F")
>
> --
>
> Kind Regards,
>
> Niek Otten
>
> Microsoft MVP - Excel
>
> "Sam" <Sam@discussions.microsoft.com> wrote in message
> news:75018EAE-E6AF-4ADA-8719-F52E1830E164@microsoft.com...
> >I am trying to create a custom function in Excel XP to automatically
> >convert
> > temperatures from Farenheit to Celsius and vice versa.
>
>

[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)


"Sam" <Sam@discussions.microsoft.com> wrote in message
news:75018EAE-E6AF-4ADA-8719-F52E1830E164@microsoft.com...
> I am trying to create a custom function in Excel XP to automatically
convert
> temperatures from Farenheit to Celsius and vice versa.