Forum Discussion
IMPRODUCT & IMCONJUGATE alternatives
Dear Experts, Could you please help me with the attached Excel, and create another sheet with the same result but with different formulae? probably if it can be done in more than 2 ...
The product of a complex number and its conjugate is the square of its amplitude.
Hence
= SQRT(IMPRODUCT(L4,IMCONJUGATE(L4)) + IMPRODUCT(M4,IMCONJUGATE(M4)) )
becomes
= SQRT(IMABS(L4)^2 + IMABS(M4)^2)
or
= SQRT(SUMSQ(IMABS(L8), IMABS(M8)))