Does Office 2000 Excel support complex numbers at all?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Ciszek - 28 Feb 2006 21:22 GMT

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.

Signature

Please reply to: | "Any sufficiently advanced incompetence is
pciszek at panix dot com | indistinguishable from malice."
Autoreply is disabled |

Reply to this Message

mikelee101@hotmail.com - 28 Feb 2006 22:22 GMT

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

Reply to this Message