Forum Discussion
complex numbers in format a+j*b, not in standard form a+b*j
Hi everyone! Long time, I would like to work with complex numbers in Microsoft Excel. I have a problem that I think here I can find one of the few people in the world capable of solving. If I...
angelohafner How Excel wants you to do this is to enter your imaginary number using =COMPLEX(3, 4). Then you can extract the real or imaginary elements using =IMREAL and =IMAGINARY. You can also use the large number of functions beginning =IM to do other kinds of imaginary number manipulation - addition, multiplication, and so on.