View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default Round-down complex numbers

On Thu, 02 Feb 2006 07:54:30 -0500, Ron Rosenfeld
wrote:

On Thu, 2 Feb 2006 05:34:53 -0600, nsv
wrote:


I have some results, that come out as complex numbers. They are
displayed in their full 15+ digit splendour, eg.
1.61189030772451+2.80510780824785i
which is a bit difficult to read.

Is it possible to round them down or display them with fewer digits?

NSV


If you are producing these by using the COMPLEX worksheet (ATP) function, then
merely round the real coefficient.

e.g.

= COMPLEX(ROUND(A1,2),A2)


--ron


Or, round both the real and the imaginary coefficients:

=COMPLEX(ROUND(A1,2),ROUND(A2,2))


--ron