engineering functions

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

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

"isa982" <isa982@discussions.microsoft.com> wrote in message news:CC4D8F8E-026A-408D-AAFF-D61CD42D32D0@microsoft.com...
| 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

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.


--
Gary''s Student


"isa982" wrote:

> 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

isa982 schrieb:

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