How do I multiply a complex number with a scalar quantity (non-complex number) in Excel? -


i'm using microsoft excel compute data analysis project in electrical engineering. need multiply complex number non-complex/scalar number. excel keeps showing me "#value!" error.

the complex number in 1 cell, , real/scalar/non-complex number in cell. i'm using formula multiply 2 numbers, , result placed in third cell. error message keeps showing every time compute.

what can do?

you make complex number 0 imaginary part , use improduct multiply them:-

=improduct(a1,complex(b1,0)) 

where a1 complex , b1 real.


Comments

Popular posts from this blog

java - Plugin org.apache.maven.plugins:maven-install-plugin:2.4 or one of its dependencies could not be resolved -

Round ImageView Android -

How can I utilize Yahoo Weather API in android -