Formatting Complex Number Functions

  • Thread starter Thread starter Dick Snell
  • Start date Start date
D

Dick Snell

Has anyone found a way to easily format the results of the
complex number functions, e.g., IMPRODUCT?
 
If you want to round the result, you will have to break it apart, round the
real and imaginary parts separately, and then recombine them, like this:
=COMPLEX(ROUND(IMREAL(A1),2),ROUND(IMAGINARY(A1),2))
 
You must log in or register to reply here.

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

Improduct function 5
Complex functions 2
Unable to access complex arithmetic functions in VBA for Excel 200 1
Complex Function in Excel 2007 VBA 2
Complex Conditional Formating 6
complex calculation 2
How do I invert a complex matrix 3
Excel How to enable engineering functions in MS Excel 2000? 3

Back
Top