Improduct function
I rekon that it will convert the complex number to the text value. Where as I
further need this number other calculations as a complex value. Other
alternative I can think of is to reconvert to a complex number but it makes
the formula so big and hard to modify in future.
Also I need to repeat these calculations.
can't we have a better solution.
"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.
|