Formatting cells with imaginary or complex quantities

1

1940LaSalle

How does one format a cell that contains an imaginary or complex
quantity (such as one containing the function IMPRODUCT) to show a
specified number of decimal places in either the real part of the
result and/or the multiplier of the imaginary quantity i? From what
I've seen, cells with complex or imaginary quantities get the general
format, and I don't see that there's an option to vary this. Thanks.
 
H

Harlan Grove

(e-mail address removed) wrote...
How does one format a cell that contains an imaginary or complex
quantity (such as one containing the function IMPRODUCT) to show a
specified number of decimal places in either the real part of the
result and/or the multiplier of the imaginary quantity i? From what
I've seen, cells with complex or imaginary quantities get the general
format, and I don't see that there's an option to vary this. Thanks.
Click to expand...

=TEXT(ROUND(IMREAL(z),3),"0.000;-0.000;")
&TEXT(ROUND(IMAGINARY(z),3),"+0.000\i;-0.000\i;")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to format a complex number 2
formatting decimal places for complex numbers 0
VLOOKUP, a table with text and numerics 7
parsing complex numbers 4
Help With Formula For Cell Addresses 2
how to add a textbox if user chooses yes in response to msgbox. 0
default values in a cell 1
Solution for if x = 1 and Y =2 goto C3 2

Top