complex numbers
complex numbers
(OP)
Is there a way to format complex numbers in Excel? I just ran a Fast Fourier Transform (FFT) and the result is a column of complex numbers. Excel shows the real and imaginary parts out to about 13 places so I need a wide column to see it.





RE: complex numbers
Just thinking aloud here ... would using
=COMPLEX(real_num,i_num,suffix)
help?
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
RE: complex numbers
=COMPLEX(ROUND(PI(),4),ROUND(PI(),4))
which means that you'll need something like
=complex(round(imreal(YOURVALUE),4),round(imaginary(YOURVALUE),4))
so, decompose to real and imaginary, apply the round function and recompose into imaginary.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: complex numbers
Along the lines of what was suggested above.... perhaps you store your complex numbers in column B with a very narrow width (don't even look at C for values), then use imreal() to display real part in column C and imaginary() to display imaginary part in column D... then use normal formatting on columns C and D
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: complex numbers