23 Oct
2011
23 Oct
'11
12:12 p.m.
[Complex numbers in Excel]
I'm not really sure since I found this by
Googling, but it seems as if
you have to enter complex numbers by entering a function. You can't just
type "5+j8" into a cell, you have to go via a dialog box. The number
will be displayed as "5+8j" (you can use anything you like instead of
"j", it is an argument to the function and presumably[hopefully] does
not take part in any calculations. What happens if you use "j" for one
number and "i" for another, and then add them, is open to speculation.
Could be interesting...)
Any arithmetic operators have to be expressed via functions.
This doesn't sound much more pleasant than using separate cells for real
and imaginary parts and writing the appropriate functions to handle them,
something that you can do in just about any spreadsheet.
There probably is a need for an 'engineer's spreadsheet' with proper
complex number support, but I guess the market is much less than for
'business' applicatiosn which only need real numbers.
-tony