Improduct function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
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.
 
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?
 
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.
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top