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 :)


--
juliadesi
------------------------------------------------------------------------
juliadesi's Profile: http://www.excelforum.com/member.php...o&userid=32476
View this thread: http://www.excelforum.com/showthread...hreadid=522621

Look in HELP for the COMPLEX() function

--
Kind regards,

Niek Otten

"juliadesi" wrote in message
...

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 :)


--
juliadesi
------------------------------------------------------------------------
juliadesi's Profile: http://www.excelforum.com/member.php...o&userid=32476
View this thread: http://www.excelforum.com/showthread...hreadid=522621

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


--
juliadesi
------------------------------------------------------------------------
juliadesi's Profile: http://www.excelforum.com/member.php...o&userid=32476
View this thread: http://www.excelforum.com/showthread...hreadid=522621

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

thank you, i'll try that :)


--
juliadesi
------------------------------------------------------------------------
juliadesi's Profile: http://www.excelforum.com/member.php...o&userid=32476
View this thread: http://www.excelforum.com/showthread...hreadid=522621

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.
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"juliadesi" wrote
in message ...

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


--
juliadesi
------------------------------------------------------------------------
juliadesi's Profile:
http://www.excelforum.com/member.php...o&userid=32476
View this thread: http://www.excelforum.com/showthread...hreadid=522621

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


--
juliadesi
------------------------------------------------------------------------
juliadesi's Profile: http://www.excelforum.com/member.php...o&userid=32476
View this thread: http://www.excelforum.com/showthread...hreadid=522621