How do I get functions added within EXCEL?

C

cgretired

I am trying to use =HEX2DEC(cell) but keep getting the "NAME" error. I
believe it is because this is not listed in my available functions.

How can I get these functions added to my copy of EXCEL?
 
R

Ron Rosenfeld

I am trying to use =HEX2DEC(cell) but keep getting the "NAME" error. I
believe it is because this is not listed in my available functions.

How can I get these functions added to my copy of EXCEL?

If your version of Excel is prior to 2007, you probably have not added the
Analysis Tool Pak.

If you look at HELP for the function, you will see a paragraph of what to do if
you see a #NAME error.

Also, HELP is a good place to look first, in general, for various Excel
problems.
--ron
 
J

John

Hi
This function show #NAME if the Analysys Toolpak is not installed.
Goto>Tools>Add-Ins> check Analysys Toolpak.
HTH
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top