The Excel Complex function takes two arguments, representing the real and the imaginary coefficients of a complex number, and from these, creates a complex number.
Syntax: COMPLEX( real_num, i_num, [suffix] )
where the arguments are as shown in the table below:
|real_num||–||The real component of the complex number|
|i_num||–||The imaginary component of the complex number|
|[suffix]||–||An optional argument that is used to specify a suffix to be used.
(For example, if we want the imaginary number 5+2i to use the suffix “j” (i.e. to be written as 5+2j), we would set the [suffix] argument to “j”)
If supplied, the [suffix] argument, must be equal to either “i” or “j”;
Excel Complex Function Examples
In the examples below, the Complex function is used to create different complex numbers in Excel.
Complex Function Common Errors
If you get an error from your Excel Complex function this is likely to be one of the following :
|#VALUE!||–||Occurs if either:
One or both of the supplied real_num or i_num arguments are non-numeric or The supplied [suffix] argument is something other than “i” or “j”
|#NAME?||–||Occurs when Analysis ToolPak add-in is not enabled in your Excel.|