Search code examples
excelcomplex-numbers

Handling complex numbers in Excel spreadsheet


I doubt an Excel spreadsheet can handle this but it's worth asking, since I have been trying and searching for a long time with no success.

Entering this into a cell:

=complex(abs(-1.5*(-1.5)^(-1.5))),0)

and the cell output is #NUM!

The output should be: 0.8164966


Solution

  • I played with this a bit and didn't get anywhere - this article may explain why. Link

    it's complicated, and I think it's more than an excel problem