COMPLEX Function

Basic Description

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”;
If omitted, this argument takes on the default value “i”

 

Excel Complex Function Examples

In the examples below, the Complex function is used to create different complex numbers in Excel.

 Formulas:
A
1 =COMPLEX( 5, 2 )
2 =COMPLEX( 5, -9 )
3 =COMPLEX( -1, 2, “j” )
4 =COMPLEX( 10, -5, “i” )
5 =COMPLEX( 0, 5 )
6 =COMPLEX( 3, 0 )
 Results:
A
1 5+2i
2 5-9i
3 -1+2j
4 10-5i
5 5i
6 3

 

 

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment