Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is the formula for converting farenheit to celsius?
I dont remember what the formula for converting temperatures from farenheit to celsius? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
"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) |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
Celcius = =(Fahrenheit-32)*5/9
-- Regards, Ron |
#8
|
|||
|
|||
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? |
#9
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |