COMPLEX

Engineering Functions:
Function: COMPLEX() - Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
(A1): Formula =COMPLEX(3,4) result is 3+4i
(A2): Formula =COMPLEX(3,4,"j") result is 3+4j
(A3): Formula =COMPLEX(3.5,4.75) result is 3.5+4.75i
(A4): Formula =COMPLEX(0,1) result is i
(A5): Formula =COMPLEX(1,0) result is 1
(A6): Formula =COMPLEX(0,-1) result is -i
(A7): Formula =COMPLEX(0,2) result is 2i
(A8): Formula =COMPLEX(2,0) result is 2