Thread: How do I set up Excel to handle complex (& imaginary) numbers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leo Heuser Leo Heuser is offline
external usenet poster
  
Posts: 266
Default 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.



Reply With QuoteReply With Quote