Improduct function
 

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.

Improduct function
 

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.

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.

Improduct function
 

I rekon that it will convert the complex number to the text value.
I need this number other calculations as a complex value.

I don't understand. Excel doesn't have a Complex object type.
Excel uses strings to represent Complex data.

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

It's in the proper string format to do other calculations:

=IMPOWER(A2,2)
correctly returns:
-1.6666+0.88877778j

(vs -5/3 + (8/9)j had we not reduced the accuracy)
Would you like a macro function instead?
--
HTH :)
Dana DeLouis


"Raj" wrote in message
...
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.

Improduct function
 

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.

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.