Most functions do not work and return #Name?

[Guest]

Most functions I enter return a #NAME? error in the field

Example Functions that do NOT work:
=QUOTIENT(5, 2)
=complex(3,4)
=IMAGINARY("3+4i")
(None of the engineering functions work)

All of the above functions return the error "#NAME?"



Example functions that work:
=sum
=odd
=even
=concatenate
Logical functions all work.


I have tried other computers at my company and it works fine.


Any ideas?

Cheers,

James


Microsoft Office Excel 2003 (11.6560.6568) SP2
Part of Microsoft Office Standard Edition 2003

 

[David Biddulph]

Go into Excel help, look up the functions QUOTIENT, COMPLEX, and IMAGINARY
and see what it says at the end of the sentence which starts:
"If this function is not available, and returns the #NAME? error, ..."

If in doubt, it's always worth trying Excel help.

 

[Rodrick]

You need to activate couple of add-ins.

Goto Tools-->Add-ins -->

Click the checkbox for Analysis ToolPak and Analysis ToolPak - VBA

and then click OK.

You might need Office CD as well, if these features were not installed at
the first time.

 

[Guest]

I had checked help(f1) numerous times, however, i glanced over the
start and scrolled to the end as this is where troubleshooting section
is usually located in manuals.
I found the remarks section where it talked about the #VALUE error and
because it did not mention #name I looked no further.

The second paragraph of the help says "If this function is not
available, and returns the #NAME? error, install and load the Analysis
ToolPak add-in."

 

[Guest]

Cheers mate.

You need to activate couple of add-ins.

Goto Tools-->Add-ins -->

Click the checkbox for Analysis ToolPak and Analysis ToolPak - VBA

and then click OK.

You might need Office CD as well, if these features were not installed at
the first time.

--
Cheers

Rodrick







- Show quoted text -