convert formula

[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

 

[Elkar]

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

 

[James Silverton]

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

 

[Ian]

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.

 

[Gord Dibben]

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

 

[daddylonglegs]

Of course, you could just use this formula.....

=C1*3.280839895