How to change complex 0.122345687+0.87659454j to 3 decimal places
 

How to change complex 0.122345687+0.87659454j to 3 decimal places

How to change complex 0.122345687+0.87659454j to 3 decimal places
 

On Tue, 4 Mar 2008 05:58:00 -0800, erwan
wrote:

How to change complex 0.122345687+0.87659454j to 3 decimal places


=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 pla
 

thank you ron but still have slight problem when doing iteration.

"Ron Rosenfeld" wrote:

On Tue, 4 Mar 2008 05:58:00 -0800, erwan
wrote:

How to change complex 0.122345687+0.87659454j to 3 decimal places


=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 pla
 

On Tue, 4 Mar 2008 06:31:01 -0800, erwan
wrote:

thank you ron but still have slight problem when doing iteration.

Please be more specific. I don't understand what you mean in this context.
--ron