Complex numbers can be tricky, there are specific functions for algebraic operations with them.
First you must enable Analysis toolpack under Add-ins.
Then in C17 and C19 you can use the following
=IMDIV(IMPRODUCT(C10,C8,COMPLEX(0,-1)),C11)
=IMPRODUCT(C15,EXP(C16),IMEXP(C17))
HTH,
Francesco
Last edited by Hydraulics; 07-03-2020 at 06:41 PM.
Aim high or don't even try.
---------------------------------
If your question has been answered, don't forget to mark the thread as SOLVED.
If you find an answer helpful, click on the star icon at the bottom of the post.
Thanks Hydraulics! Works well. Quick question, how can I round the real and imaginary part to show 4 decimal places ,each? I have inserted the round function in several locations within the equation, but I keep receiving the #VALUE! Error.
Hydraulic, Thanks! See my additional question down below. I was able to round the 4 decimals, but I had to break the results with:
=IMREAL(C19)
=IMAGINARY(C19)
=COMPLEX(ROUND(C21,4),ROUND(C22,4))
I want to round in cell C19 and minimize breaking into parts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks