Microsoft Office Tutorials and References
In Depth Information
Where the square root of a complex number is as follows:
See the COMPLEX function earlier in this chapter for obtaining the complex number of real and
imaginar y coefficients.
Returns the square root
of complex numbers
x+yi or x+yj in text
Returns the difference of two complex numbers in x+yi or x+yj text format with IMSUB .
The IMSUB 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. The example in Figure 5.34 shows the difference when
two complex numbers are subtracted.