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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> 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 calculat
with the

--
juliades
-----------------------------------------------------------------------
juliadesi's Profile: http://www.excelforum.com/member.php...fo&userid=3247
View this thread: http://www.excelforum.com/showthread.php?threadid=52262

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 :

--
juliades
-----------------------------------------------------------------------
juliadesi's Profile: http://www.excelforum.com/member.php...fo&userid=3247
View this thread: http://www.excelforum.com/showthread.php?threadid=52262

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" <(E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>
> 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 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

--
juliades
-----------------------------------------------------------------------
juliadesi's Profile: http://www.excelforum.com/member.php...fo&userid=3247
View this thread: http://www.excelforum.com/showthread.php?threadid=52262