=COMPLEX(0,1) returns Complex number with 0 and 1 as the real and imaginary coefficients : COMPLEX « Engineering functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Engineering functions
  3. COMPLEX
Input the formula: =COMPLEX(0,1). Press Enter to get the result
Input the formula: =COMPLEX(0,1)
16.8.COMPLEX
16.8.1.=COMPLEX(3,4) returns Complex number with 3 and 4 as the real and imaginary coefficients=COMPLEX(3,4) returns Complex number with 3 and 4 as the real and imaginary coefficients
16.8.2.=COMPLEX(3,4,"j") returns Complex number with 3 and 4 as the real and imaginary coefficients, and j as the suffix (3 + 4j)=COMPLEX(3,4,
16.8.3.=COMPLEX(0,1) returns Complex number with 0 and 1 as the real and imaginary coefficients=COMPLEX(0,1) returns Complex number with 0 and 1 as the real and imaginary coefficients
16.8.4.=COMPLEX(1,0) return Complex number with 1 and 0 as the real and imaginary coefficients=COMPLEX(1,0) return Complex number with 1 and 0 as the real and imaginary coefficients