Need to convert temperature from Farenheit to Celsius

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a custom function in Excel XP to automatically convert
temperatures from Farenheit to Celsius and vice versa.
 
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
 
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)
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the formula for converting farenheit to celsius? 8
FORMULA FOR CELSIUS TO FAHRENHEIT 8
Computer chip developed that can survive surface of Venus 3
Is there a way to format numbers to show as degrees farenheit? 1
System.Web.Services.WebMethod( Description:= ...) 2
Flagship Ryzen 1800X processor sets new world record benchmark 0
Example calling an external webservice 10
LGA775 Temperature 4

Back
Top