Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
engineering functions
The Engineering functions are part of Analysis Toolpak.
ToolsAdd-ins, check Analysis Toolpak. Now there should be an Engineering category in your function list. -- Kind regards, Niek Otten "isa982" 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
engineering functions
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
engineering functions
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
How can I use engineering functions in Excel 2003 | Excel Discussion (Misc queries) | |||
How to load Engineering Functions into the Fx function wizard? | Excel Worksheet Functions |