No, this is not the way complex calculations work.
My formula could eg. go like this in cell A3: COMPLEX(A1;A2) which
leaves a complex number based on the input from cell A1 and A2.
I know it is possible write IMREAL(A3) in cell B1 and IMAGINARY(A3) in
cell B2, round them of to a few digits and then write =B1&" + j"&B2 in
cell B3, but that is not the smart solution I look for.
--
nsv
------------------------------------------------------------------------
nsv's Profile:
http://www.excelforum.com/member.php...o&userid=26500
View this thread:
http://www.excelforum.com/showthread...hreadid=507597