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."


On Oct 17, 4:42 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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.
--
David Biddulph

wrote in message

ps.com...



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- Hide quoted text -

- Show quoted text -