What is the formula for converting farenheit to celsius?

  • Thread starter Thread starter Guest
  • Start date Start date
use the CONVERT excel worksheet function as follows:
=CONVERT(A1,"F","C")

where A1 holds the temperature

You need to enable the Analysis ToolPak addin.

The formula is:
=(A1-32)*5/9


Mangesh
 
SWPT4330,

farenheit to celsius is:-
Tc = (5/9)*(Tf-32); Tf = temperature in degrees Fahrenheit

celsius to farenheit is :-
Tf = (9/5)*Tc+32; Tc = temperature in degrees Celsius

HTH

Pank
 

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

Need to convert temperature from Farenheit to Celsius 4
Four User Defined Functions - probably one similar answer 7
Weather gadget trouble (again) 3
Is there a way to format numbers to show as degrees farenheit? 1
FORMULA FOR CELSIUS TO FAHRENHEIT 8
VBA user-defined worksheet function 2
HOT - AND I MEAN HOT Motherboard and CPU 35
Convert farenheit to celcius 6

Back
Top