convert formula

  • Thread starter Thread starter April
  • Start date Start date
A

April

Hi

I am trying to convert a cell from metre to ft. The formula I use is
=convert(C1,"m","ft"). This results in #NAME? If I put a number in place
of C1, the formula still does not work.

I'd appreciate it if someone could let me with why this is happening.

Thank you in advance
 
The CONVERT function is part of the Analysis ToolPak Add-In. You'll need to
activate that first.

TOOLS
ADD-INS
Check "Analysis ToolPak"
OK

HTH,
Elkar
 
Hello, April!
You wrote on Thu, 2 Nov 2006 20:45:57 -0000:

A> I am trying to convert a cell from metre to ft. The formula
A> I use is =convert(C1,"m","ft"). This results in #NAME? If
A> I put a number in place of C1, the formula still does not
A> work.

A> I'd appreciate it if someone could let me with why this is
A> happening.

Did you try HELP? The reason for getting #NAME is specifically
mentioned: you don't have the Analysis Toolpack installed.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
 
Convert is part of the Analysis ToolPak add-in. It returns #NAME because the
add-in is not present and Excel does not recognise the function.
 
Tools>Add-ins>Checkmark in Analysis ToolPak to load it.

The ATP contains the CONVERT function.

If you had looked for "convert" in Help you would have seen the warning about
#NAME? and the ATP.


Gord Dibben MS Excel MVP
 
Back
Top