What is the formula for converting farenheit to celsius?

S

swpt4330

I dont remember what the formula for converting temperatures from
farenheit to celsius?
 
M

Markus L

swpt4330 said:
I dont remember what the formula for converting temperatures from
farenheit to celsius?

=CONVERT(A1,"F","C")
(needs Analysis ToolPak Add-In)
 
M

mangesh_yadav

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
 
P

Pank

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
 
Top