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.