ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What is the formula for converting farenheit to celsius? (https://www.excelbanter.com/excel-worksheet-functions/30974-what-formula-converting-farenheit-celsius.html)

swpt4330

What is the formula for converting farenheit to celsius?
 

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

JE McGimpsey

F = 1.8C + 32

C = (F - 32)/1.8



In article ,
"swpt4330" wrote:

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


Markus L

"swpt4330" wrote in message
...

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


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



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


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379587


paul

excel will do it for you!.Check out the convert function
--
paul
remove nospam for email addy!



"swpt4330" wrote:


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


bj

one is
=(fahr+40)*5/9-40
or
=(fahr-32)*5/9


"swpt4330" wrote:


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


Ron Coderre

Celcius = =(Fahrenheit-32)*5/9

--
Regards,
Ron


bj

This may be a second response
=(fahr+40)*5/9-40
or
=(fahr-32)*5/9

"swpt4330" wrote:


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


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


"swpt4330" wrote:


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



All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com