Improduct function
D15=IMPRODUCT(Data!D13, (Data!D$5/Data!D$8)^2))
4.69452551984877E-002+0.121677051039698j
Would this idea work?
=COMPLEX(ROUND(IMREAL(D15),4),ROUND(IMAGINARY(D15) ,4))
--
Dana DeLouis
Windows XP & Excel 2007
"Raj" wrote in message
...
You wanted to use:
=COMPLEX(1/3,4/3)
0.333333333333333+1.33333333333333i
and reduce it to 4 significant digits each
+ 0.3333 + 1.3333j
That is right. I want to do the same. If I enter it using complex
function,
it is much user friendly as compare to entering as text value as there are
lot of complex values I need to enter. Also when you multiply or divide
with
result from some other cell , that particular value has to be rounded to
reduce the significant digits.
Below is the example I am trying to use.
D13=COMPLEX(0.05131,0.13299,"j")
D5=66
D8=69
D15=IMPRODUCT(Data!D13, (Data!D$5/Data!D$8)^2))
It gives me the result as
4.69452551984877E-002+0.121677051039698j
So I tried to round it by using
D15=IMPRODUCT(Data!D13, round(Data!D$5/Data!D$8)^2,3))
And the result is 4.694865E-002+0.12168585j
Although it is bit better than the first one but still look odd.
Is there something straight forward like cell formatting we can apply to
minimize the significant digits.
Any suggestions please.
"Dana DeLouis" wrote:
however so many ddecimal igits are not desired. Can we restrict the
decimal
digits from the formula say 4 to 5.
Would this idea work for you?
=TEXT(IMREAL(A1)," + 0.####; - 0.####") & TEXT(IMAGINARY(A1)," +
0.####; -
0.####") & "j"
--
HTH :)
Dana DeLouis
"Raj" wrote in message
...
When I try to multiply the complex number by a fixed number the result
comes
out to be
4.69452551984877E-002+0.121677051039698j
The formula looks like
=IMPRODUCT(Data!D13,(Data!D5/Data!D8)^2)
where Data!d3 is a complex number and Data!D5 and Data!D8 are numbers .
however so many ddecimal igits are not desired. Can we restrict the
decimal
digits from the formula say 4 to 5.
|