Display absolute value of complex number
How do I change the format of an Excel cell containing a complex number to
just display the absolute value of the complex number,
I don't believe Excel's formatting can do this alone. I think you would
need an additional function.
If A1 has the text 3+4i
then
=IMABS(A1)
retuns 5
--
HTH :)
Dana DeLouis
Windows XP & Office 2003
"GraemeD" wrote in message
...
How do I change the format of an Excel cell containing a complex number to
just display the absolute value of the complex number, or failing that,
reduce the number of digits displayed ?
|