+ Reply to Thread
Results 1 to 5 of 5

Convert Farenheit to Celcius

  1. #1
    Registered User
    Join Date
    01-26-2005
    Posts
    2

    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. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    You'll need to enable the Analysis ToolPak add-in...

    Tools > Add-Ins > and check Analysis ToolPak

    Hope this helps!

    Quote 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. #3
    Forum Contributor
    Join Date
    04-30-2004
    Posts
    122
    ...or you could just type in the formula

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

  4. #4
    Forum Contributor
    Join Date
    06-23-2004
    Location
    Houston, TX
    Posts
    571
    Quote 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
    BenjieLop
    Houston, TX

  5. #5
    Registered User
    Join Date
    01-26-2005
    Posts
    2

    The Add in worked like a charm!

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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