Microsoft Office Tutorials and References
In Depth Information
COMPLEX
Figure 5.7
BIN2OCT converts a
binary number to an
octal. The binary
number cannot be more
than 10 characters.
COMPLEX
Use the COMPLEX function to convert real and imaginar y coefficients into a complex number of
the form x + yi or x + yj .
=COMPLEX(real_num,I_num,suffix)
The COMPLEX function is found only if the Analysis Toolpak is installed. In addition it must be
turned on in the Add-Ins from the Tools menu. Lowercase “i” and “j” must be used for the
suffix argument in order for the function to work. In addition the suffixes must match. Notice
the example in Figure 5.8, where the Real Imaginar y Coefficient is 3 and the Imaginar y
Coefficient is 4, the result is 3+4i.
The real coefficient of the complex number.
REAL_NUM
The imaginar y coefficient of the complex number.
I_NUM
The suffix for the imaginar y component. If omitted, it’s assumed
to be “i.”
SUFFIX
Figure 5.8
Converts real and
imaginary coefficients
into a complex number.
Search JabSto ::




Custom Search