COMPLEX(real_num, i_num [,suffix])

Returns the complex number given real and imaginary coefficients.

real_numThe real coefficient of the complex number.
i_numThe imaginary coefficient of the complex number.
suffix(Optional) The suffix for the imaginary component of the complex number.

Remarks

* If "real_num" is not numeric, then #VALUE! is returned.
* If "i_num" is not numeric, then #VALUE! is returned.
* If "suffix" is left blank, then "i" is used.
* If "suffix" is not either "i" or "j", then #VALUE! is returned.
* If "suffix" is not in lowercase, then #VALUE! is returned.
* You can use the IMCONJUGATE function to return a complex conjugate.
* For the Microsoft documentation refer to support.microsoft.com

 A
1=COMPLEX(3,3) = 3+3i
2=COMPLEX(3,4,"i") = 3+4i
3=COMPLEX(3,4,"j") = 3+4j
4=COMPLEX(0,1) = i
5=COMPLEX(1,0) = 1
6=COMPLEX(3,4,"I") = #VALUE!
7=COMPLEX(1,0,"J") = #VALUE!
8=COMPLEX(1,0,"a") = #VALUE!

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top