Forum Discussion
Complex numbers in Excel
Did you know that Excel can handle complex mathematical operations with complex numbers? Complex numbers, expressed as "a + bi," where 'a' and 'b' are real numbers and 'i' is the imaginary unit, can ...
I am an electrical engineer. So we use complex numbers all the time for RLC circuits etc. Not everyone has a Matlab license so I thought I would show my calculations in Excel. Having to use the functions to manipulate the numbers (add/multiply etc.) was a little clunky, but ok. It would also be nice if they could be formatted (to limit the number of decimal places displayed). Still, as it stands, it is useful, and a good start.
