How to change complex 0.122345687+0.87659454j to 3 decimal places
R Ron Rosenfeld Mar 4, 2008 #2 How to change complex 0.122345687+0.87659454j to 3 decimal places Click to expand... =COMPLEX(ROUND(IMREAL(A1),3),ROUND(IMAGINARY(A1),3),"j") or, if you might have either an "i" of "j" suffix: =COMPLEX(ROUND(IMREAL(A1),3),ROUND(IMAGINARY(A1),3),RIGHT(A1,1)) --ron
How to change complex 0.122345687+0.87659454j to 3 decimal places Click to expand... =COMPLEX(ROUND(IMREAL(A1),3),ROUND(IMAGINARY(A1),3),"j") or, if you might have either an "i" of "j" suffix: =COMPLEX(ROUND(IMREAL(A1),3),ROUND(IMAGINARY(A1),3),RIGHT(A1,1)) --ron
R Ron Rosenfeld Mar 4, 2008 #4 thank you ron but still have slight problem when doing iteration. Click to expand... Please be more specific. I don't understand what you mean in this context. --ron
thank you ron but still have slight problem when doing iteration. Click to expand... Please be more specific. I don't understand what you mean in this context. --ron
