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

P

Peter Thompson

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

Leo Heuser

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

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