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
Post a Comment