close

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.
Toolsgt;Add-ins, check Analysis Toolpak.
Now there should be an Engineering category in your function list.
--
Kind regards,

Niek Otten

quot;isa982quot; gt; wrote in message ...
| 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 Studentquot;isa982quot; wrote:

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


isa982 schrieb:

gt; hi,
gt;
gt; i want to perform a complex operation (operation which involves complex
gt; numbers i.e. (1 i)*(2-3i). how can i do this? i have read the help and it
gt; asked me to select engineering function which i cannot find in my excel's
gt; 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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()