Learn Excel - Simplify Life with Excel Concepts

## Excel COMPLEX Function ### How to use the COMPLEX Function

This Excel tutorial explains how to use the Excel COMPLEX function with syntax and examples.

### SUMMARY:

The Excel COMPLEX function converts coefficients (real and imaginary) into a complex number of the form x + yi or x + yj.

The complex number can be in either form, x + yi or x + yj.

For example,

• The formula =COMPLEX(2,5) would return 2+5i
• The formula =COMPLEX(2,5,"j") would return 2+5j

### PURPOSE:

To converts coefficients to complex number.

### RETURN VALUE:

The COMPLEX function returns a Complex number as text.

### SYNTAX:

=COMPLEX(real_num, i_num, [suffix])

### ARGUMENTS:

The COMPLEX function syntax has the following arguments:

• real_num: Required. The real component of the complex number.
• i_num: Required. The imaginary coefficient of the complex number.
• suffix: Optional. It is either "i" or "j" which is to represent the suffix for the imaginary component of the complex number.
• If suffix is omitted, it assumes that suffix is "i".
• All complex number functions accept "i" and "j" for suffix, but neither "I" nor "J". Using uppercase results in the #VALUE! error value. All functions that accept two or more complex numbers require that all suffixes match.

### REMARKS:

• If real_num is non-numeric, COMPLEX returns the #VALUE! error value.
• If i_num is non-numeric, COMPLEX returns the #VALUE! error value.
• If suffix is neither "i" nor "j", COMPLEX returns the #VALUE! error value.
• If suffix is entered in uppercase (ie "I" or "J" instead of "i" or "j"), the COMPLEX function will return a #VALUE! error.
• The COMPLEX function returns a string/text value.