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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to view & work with a spreadsheet that contains complex numbers.
Right now the cells with complex numbers show up as #NAME?.
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Goal Seek with Complex Numbers 2
how to format a complex number 2
How do I invert a complex matrix 3
IF statement problem with IMAGINARY 4
Excel How to enable engineering functions in MS Excel 2000? 3
complex calculation 2
Format cell containing complex number 1
Most functions do not work and return #Name? 4

Back
Top