View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten
 
Posts: n/a
Default complex calculations

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