engineering functions

[Guest]

hi,

i want to perform a complex operation (operation which involves complex
numbers i.e. (1+i)*(2-3i). how can i do this? i have read the help and it
asked me to select engineering function which i cannot find in my excel's
function list. thank you

 

[Niek Otten]

The Engineering functions are part of Analysis Toolpak.
Tools>Add-ins, check Analysis Toolpak.
Now there should be an Engineering category in your function list.
--
Kind regards,

Niek Otten

| hi,
|
| i want to perform a complex operation (operation which involves complex
| numbers i.e. (1+i)*(2-3i). how can i do this? i have read the help and it
| asked me to select engineering function which i cannot find in my excel's
| function list. thank you

 

[Guest]

Use IMPRODUCT():


It returns the product of 2 to 29 complex numbers in x + yi or x + yj text
format.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

 

[wdrechsel]

hi,

i want to perform a complex operation (operation which involves complex
numbers i.e. (1+i)*(2-3i). how can i do this? i have read the help and it
asked me to select engineering function which i cannot find in my excel's
function list. thank you

Hallo,

You can find an excel file to perform complex operations with excel on
my page:
www. wolfgang-drechsel.de. It uses macros and the excel included
functions for complex numbers.