How do I set up Excel to handle complex (& imaginary) numbers?
 

I need to view & work with a spreadsheet that contains complex numbers.
Right now the cells with complex numbers show up as #NAME?.

How do I set up Excel to handle complex (& imaginary) numbers?
 

"Peter Thompson" <Peter skrev i en
meddelelse ...
I need to view & work with a spreadsheet that contains complex numbers.
Right now the cells with complex numbers show up as #NAME?.

Hi Peter

Use COMPLEX(), which is an ordinary Excel function, to
convert real and imaginary coefficients into a complex number.
All functions for complex numbers reside in Analysis ToolPak
(not my spelling :-) and start with IM (e.g IMABS()), so you have
to install and activate Analysis ToolPak (Tools Add-ins) in
order to use those functions.


--
Best regards
Leo Heuser

Followup to newsgroup only please.

How do I set up Excel to handle complex (& imaginary) numbers?
 

Coudl you give us an example of a few of these complex numbers?


Peter Thompson wrote:
I need to view & work with a spreadsheet that contains complex numbers.
Right now the cells with complex numbers show up as #NAME?.