complex calculations

[juliadesi]

hi!

i need to do some calculations using complex numbers but when i try i
always get #VALUE.

an example of what i'm trying to do:

in cell C4: 0,41252365423753+4,8265267545791E-003i


the calculation: 1/C4


can excel not do these calculations? if not, could you please suggest
another appropriate programm with which i could do these calculations
(as the actual calculations are more complex than the example and i
need to repeat them over 300 times, please don't suggest using a
calculator)

cheers

 

[Niek Otten]

Look in HELP for the COMPLEX() function

 

[juliadesi]

i know how to typ in complex numbers, i'm just not able to calculat
with the

 

[Mike Middleton]

juliadesi -

i know how to typ in complex numbers, i'm just not able to calculate with
them <

To calculate, maybe you could use worksheet functions IMSUM, IMSUB,
IMPRODUCT, ...

- Mike
www.mikemiddleton.com

 

[juliadesi]

thank you, i'll try that :

 

[Dana DeLouis]

Hi. I'm using the US version of Excel (ie. decimal point vs comma)
If A1 has the text string:
0.41252365423753+4.8265267545791E-003i

Then the formula is:
=IMDIV(1,A1)

Returns the correct answer: 2.423-2.835E-002i

Excel treats complex numbers as strings, so math operations involve using
special functions.

 

[juliadesi]

finally i found the problem: i kept doing exactly as the help file tol
me to do, however, my version did not accept this, for the IMDI
function, for example, it told me to put a comma, but i have to put
semi-colon. stupid microsoft