D Dick Snell Nov 26, 2003 #1 Has anyone found a way to easily format the results of the complex number functions, e.g., IMPRODUCT?
Has anyone found a way to easily format the results of the complex number functions, e.g., IMPRODUCT?
S Stephen Bye Nov 27, 2003 #2 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))
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))
