# Convert Farenheit to Celcius

1. ## Convert Farenheit to Celcius

I looked this up in MS help in Excel and it says to use this:
=convert(A1, "F", "C") a1 being the first cell with a farenheit degree in
it.
I thought, "What a snap!" but once I hit return I got the old #NAME? error.
Anyone know what I am doing wrong?

Thanks for any help.

2. You'll need to enable the Analysis ToolPak add-in...

Tools > Add-Ins > and check Analysis ToolPak

Hope this helps!

Originally Posted by kndfrnd
I looked this up in MS help in Excel and it says to use this:
=convert(A1, "F", "C") a1 being the first cell with a farenheit degree in
it.
I thought, "What a snap!" but once I hit return I got the old #NAME? error.
Anyone know what I am doing wrong?

Thanks for any help.

3. ...or you could just type in the formula

=(A1*5/9)-(32*5/9)

4. Originally Posted by kndfrnd
I looked this up in MS help in Excel and it says to use this:
=convert(A1, "F", "C") a1 being the first cell with a farenheit degree in
it.
I thought, "What a snap!" but once I hit return I got the old #NAME? error.
Anyone know what I am doing wrong?

Thanks for any help.
You need to have AddIn for this. Anyway, the formula to convert:

ºF to ºC : (ºF-32)*5/9

ºC to ºF : 1.8*(ºC)+32

5. ## The Add in worked like a charm!

Thanks everyone for that piece of info! Add-ins, I always forget about those.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1