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
|