Convert farenheit to celcius

L

Lisa

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?
 
B

Bob Phillips

Quote from help

If this function is not available, run the Setup program to install the
Analysis ToolPak. After you install the Analysis ToolPak, you must enable it
by using Add-Ins on the Tools menu.


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
L

Lisa

Excellent suggestion Bob! It worked and my cutoemr is very happy now! Next
time I'll try to read the help article. Thanks again.
 
B

Bob Phillips

Hi Lisa,

Glad it's sorted. Excel help isn't the best in the world, but it's always
worth a look :).

Bob
 
S

Samad

Nice reply by bob,
Thanks bob it was really helpful but can you or any one tell me what other
formulas does Analysis tool pak add-in have?

Thanks
 
Top