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.
Diffrent way to use the COMPLEX function...
COMPLEX Function Error:
- #VALUE! error:
- Occurs if one or both of the supplied real_num or i_num arguments are non-numeric.
- Occurs if the supplied [suffix] argument is something other than "i" or "j".
