Does Office 2000 Excel support complex numbers at all?


P

Paul Ciszek

OK, so I re-installed Office 2000, and I selected every concievable
option in the Analysis ToolPack and set them all to run off of my
computer. After installing, I went into Add-Ons and checked every
thing that could be checked. Yet, I still get "#NAME?' when try to
enter the function =COMPLEX(1,2,i) The Excel help file seems to think
this is legit, but Excel itself hasn't heard of it.
 
Ad

Advertisements

M

mikelee101

I don't have any experience with this function, so I may be wrong, but
try enclosing the suffix argument in quotation marks.

=complex(1,2,"i")

It may be that it's looking for a range named i instead of using "i" as
the argument.

Hope that helps.

Mike
 

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