The COMPLEX function converts real and imaginary coefficients into a complex number.

COMPLEX takes 2 required arguments and 1 optional argument:

Syntax: COMPLEX(real_num, i_num, [suffix])

#1)
Using the COMPLEX function:
#2)
The arguments for the COMPLEX function are:
Argument Required? Description
real_num Required The real coefficient of the complex number.
i_num Required The imaginary coefficient of the complex number.
suffix Optional The suffix for the imaginary component of the complex number. If omitted, suffix is assumed to be "i".
#3)
A few more things:
If real_num is nonnumeric, COMPLEX returns the #VALUE! error value.
If i_num is nonnumeric, COMPLEX returns the #VALUE! error value.
If suffix is neither "i" nor "j", COMPLEX returns the #VALUE! error value.

Summary

The COMPLEX function converts real and imaginary coefficients into a complex number.
comments powered by Disqus