Display absolute value of complex number

G

GraemeD

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 ?
 
D

Dana DeLouis

How do I change the format of an Excel cell containing a complex number to
just display the absolute value of the complex number,
Click to expand...

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
 
Top